Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Aloha,
I have in col D 7:00 E 7:45 F 7:15 G 7:46
Am using this formula to count occurences
IF(F7<>"",IF(G7<>"",IF(AND(ROUND((G7-F7),5)>ROUND((E7-D7),5),G7>E7),0,1),""),"")
How can I add another IF statement to ask IF 475, then 45 mins, occurrence should be 0
Brian
I have in col D 7:00 E 7:45 F 7:15 G 7:46
Am using this formula to count occurences
IF(F7<>"",IF(G7<>"",IF(AND(ROUND((G7-F7),5)>ROUND((E7-D7),5),G7>E7),0,1),""),"")
How can I add another IF statement to ask IF 475, then 45 mins, occurrence should be 0
Brian