#### catherinemoore

##### New Member

- Joined
- Oct 10, 2006

- Messages
- 10

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