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, `=C4-B4`

.

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?

`Time In | Time Out | Total Time`

and`Total Time`

is`=(C4-B4`

)*24`. With that, can't you just`

=37-<Total Time>`? – shinjijai May 2 '14 at 14:26`Total Time`

is simply`=C4-B4`

- why would it be`=(C4-B4)*24`

? – Eilidh May 2 '14 at 14:34