I'm trying to write an Excel sheet which calculates Flexi-time hours remaining to be worked in a week.
The user may enter the time they started work and the time they ended work, and the spreadsheet will calculate how many hours they worked that day. This is (obviously) a simple formula,
However, if I try to take this same approach to calculate the hours remaining to be worked in a week (i.e. 37 - 11, or, more accurately,
=TIME(37,0,0) - TIME(11,0,0)) then it does not work, because the time is automatically converted to 24 hour time, so the answer, 26, would in fact become 2.
Is there a way to work with hours which gets around this issue whilst preserving the precision of times?
I have seen similar spreadsheets made where the user may simply calculate hours worked in decimal (i.e. 18.5 for 18 and a half hours) however I would like to preserve the accuracy a TIME format can provide.
Is there any way around this?