Related:
- Excel formule
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
2 responses
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...!!!
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
Can you give an example of how your worksheet(s) look like?
You want to find duplicate entries?
Best regards,
Trowa
Hi Trowa,
I don't know if my reply reached your email address. if you want i can send you a screen shot of the grille. But it is something like this:
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
I don't know if my reply reached your email address. if you want i can send you a screen shot of the grille. But it is something like this:
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
