# Excel formule

[Closed]
-
glg23 -
Hello,
I'am trying to make a template schedule in excel that can show me at what time I have gaps in the schedule and at what times I have over 3 people covering the same shift (A1 7:30 am B1 12:30 pm) . So I need compare blocks of hours composed for these two columns (eg,start -A1=7:30 am, B1=12:30 pm if it is repeated in same day). next shift 12:30 pm 6:00 pm find out if nobody is covering this shift.

## 2 replies

Hello,
Column B= workers names, the rest of columns: weekly days, e.g Monday C= time in (7:30 AM) d= time out (12:30 PM); Tuesday E & F, Wednesday G & H, etc. The shifts go spread from 7:30 AM to 12:00 AM (0:00) in blocks of 4 or 5 hours. So I need find out when there are more than two people at the same shift and when I have a gap during the day. That means nobody working during same hours or less than two people.
If you can resolve this, you are a genius plus...!!!
Hi GLG23,

Can you give an example of how your worksheet(s) look like?

You want to find duplicate entries?

Best regards,
Trowa
Hi Trowa,

Column B= workers names, the rest of columns: weekly days, e.g Monday C= time in (7:30 AM) d= time out (12:30 PM); Tuesday E & F, Wednesday G & H, etc. The shifts go spread from 7:30 AM to 12:00 AM (0:00) in blocks of 4 or 5 hours. So I need find out when there are more than two people at the same shift and when I have a gap during the day. That means nobody working during same hours or less than two people.
If you can resolve this, you are a genius plus...!!!

I hope you can resolve this, because I could't.

Best regards,

GLG23