I created a spreadsheet for making schedules, and am attempting to force time to display in hours (as in 7.5 hours), instead of normal time (7:30). I can't find a decent way of displaying it properly. Here's how I have it set up currently:
B5: Start_Time
C5: End_Time
B6: =IF(C5-B5>0.166666666666667;C5-B5-0.0208333333333333;C5-B5)
The formula in B6 just checks to see if the scheduled shift is MORE than 4 hours long, and if so, subtracts half an hour from the shift (for a lunch break), and then displays the result. I would like the result to appear in hour format, as in 7.5, instead of time format, like it is currently. I have attempted every variation of the number formatting I could think of, as well as searched numerous forums (including this one). Any help you could offer would be greatly appreciated.
Bookmarks