Hi Forum,
I am trying to develop a universal excel formula in Office 365 to calculate the number of Late Hours or Night Hours worked on any shift.
The universal formula should be able to do the calculation for any Shift start and end times and for any Late premium and Night premium intervals.
In the example below, I will use the formula to calculate "Hrs?" in decimal format (e.g. 7.5 Hours).
Can you help?
Fran99, Dublin.
Week Mon Tue Wed
Shift Start 1 07:00 21:00 15:00
End 17:00 07:00 01:00
Hours Worked 10 10 10
Late 18:00 Hrs? Hrs? Hrs?
20:00
Night 20:00 Hrs? Hrs? Hrs?
08:00
Bookmarks