How to Calculate Hours Worked in Excel (Past Midnight Span)
In this video, we will learn how to calculate hours worked for a second shift (a night shift) in which the end time spans midnight.
In the earlier video, we saw how to calculate hours worked when the 'Start work time' and 'End work time' are in the same day.
However, you will require an 'If' statement to calculate the correct number of hours if the working time spans midnight (when the 'End work time' is in the next day).