time tracking formula needed
 

This worksheet tracks equipment run time. Is there a formula that could
automatically enter a 'Y' or 'N' in column (B) based upon time it is turned
off and on in columns (C) and (D)? You will notice that even tho it was
turned off at 5am, there is a 'Y' in that slot. The actual worksheet tracks
24 hrs/day.
Thanks for any help.

(A) (B) (C) (D)
-----------------------------------------------
ON? OFF ON
*Y / N (time) (time)
---------------------------------
1a-2:59a Y
3a-4:59a Y
5a-6:59a Y 5:00
7a-8:59a N
9a-10:59a Y 9:15
11a-12:59p Y