hi there,
im struggling with a formula to calculate how many hours worked between 24:00 and 04:00 for shift workers.
if a guy starts at 21:00 and finishes at 03:45 then the answer would be 3:45. if he starts at 01:00 and finishes at 06:00 then the answer would be 3:00 etc
start time - column a
finish time - column b
answer column - c
all times are entered in 24hr format
Bookmarks