catherinemoore
New Member
- Joined
- Oct 10, 2006
- Messages
- 10
I need help with the formula in F4. In row 4 the working hours are entered for the day. In row 5, any callout hours are added. The aim is to show "N" in F4 if there is less than a 12 hour gap between each finish time and the next start time, or show "Y" if there are 12 hours or more.
I need to include the following in the formula to get an "N" result:
(hrs between D4 & C5)>12
(hrs between D4 & G4)>12
(hrs between D4 & G5)>12
(hrs between D5 & G4)>12
(hrs between D5 & G5)>12
(hrs between G4 & G5)>12
So far I have included the first two criteria in the formula, but it's already pretty lengthy, so if anyone has any ideas on how to simplify it, I would really appreciate it!
Thanks.
Catherine
I need to include the following in the formula to get an "N" result:
(hrs between D4 & C5)>12
(hrs between D4 & G4)>12
(hrs between D4 & G5)>12
(hrs between D5 & G4)>12
(hrs between D5 & G5)>12
(hrs between G4 & G5)>12
So far I have included the first two criteria in the formula, but it's already pretty lengthy, so if anyone has any ideas on how to simplify it, I would really appreciate it!
HOURS.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | |||
2 | SUNDAY | REST | MONDAY | REST | ||||||
3 | START | FINISH | HRS | 13/14 | START | FINISH | HRS | 13/14 | ||
4 | 08:00 | 16:00 | 8.0 | N | 08:00 | 16:00 | 8.0 | |||
5 | 22:00 | 23:00 | 1.0 | 0.0 | ||||||
Worked Hrs |
Thanks.
Catherine