Need help to simplify a nested formula

[catherinemoore]

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!

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

 

[catherinemoore]

Don't worry - I've sorted it. The formula is:

=IF(MIN(IF(ISBLANK(C5),10,IF(ISBLANK(D4),10,C5-D4)),IF(ISBLANK(D4),10,IF(ISBLANK(G4),10,1-D4+G4)),IF(ISBLANK(D4),10,IF(ISBLANK(G5),10,1-D4+G5)),IF(ISBLANK(D5),10,IF(ISBLANK(G4),10,1-D5+G4)),IF(ISBLANK(D5),10,IF(ISBLANK(G5),10,1-D5+G5)),IF(ISBLANK(G5),10,IF(ISBLANK(H4),10,G5-H4)))<0.5,"N","Y")

Regards

Catherine