Forum Discussion
LindsayD513
Jan 16, 2022Copper Contributor
If/Then Forumla to subtract hours
I'm setting up a spreadsheet to display a work schedule at my part-time restaurant job. The majority of it is finished, but I forgot about having the cells calculate hours for shifts worked that are ...
HansVogelaar
Jan 16, 2022MVP
Let's say start time is in B2 and end time in C2.
=24*MOD(C2-B2,1)-(24*MOD(C2-B2,1)>=6)/2
This will also work if you start before midnight and end after midnight.
The formula can be filled down.