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 ...
SergeiBaklan
Jan 16, 2022Diamond Contributor
It depends also you'd like to show shift time as the time or calculate number of hours in the shift. In Excel 1 hour is actually decimal number which is equal to 1/24. What we show as 01:00 is only human friendly notation. Variants are