Good Day,
I have two cells in my Excel file that contains the Start and Stop time, I was able to get the time difference between the 2 cells. Their cell format is dd/mm/yyyy 00:00 PM/AM (Custom).
I want to get the time differential (night shift) between the two cells but I can't figure it out. Night shift starts at 10:00 PM - 6:00 AM (next day), please see sample below.
C2: 08-July-2010 8:00 PM (Start)
D2: 09-July-2010 8:00 AM (Stop)
Would appreciate if you could help me build a formula to get the time accumolated for night differential.
Thank you.
Bookmarks