Help with Time format

[Quisp]

Can someone please explain to me why the result in M14 shows 7 Hrs and 60 Min, rather than 0 Min?

[Special-K]

Prob a rounding problem.

Use
=INT(L10)&" Hrs "&MOD(L10,1)*60&" mins"

though I keep getting a VALUE error in your spreadsheet, this works in a blank spreadsheet though.

[MrShorty]

As Special-K notes, this looks like standard floating point error (a few links discussing floating point errors https://www.excelforum.com/groups/ma...nd-errors.html ). To see this, I entered =(L14-7) into a convenient cell and formatted as scientific (result was -8.9E-16, suggesting a value slightly smaller than exactly 7).

Rather than fix this in M like Special-K suggests, I would probably fix this in column L. Nest the existing function inside of a ROUND() function =ROUND(current function,2) [note that I picked 2 decimals to round to because your number format rounds all numbers to the nearest hundredth of an hour. Replace the 2 with a more suitable value, if needed].

[protonLeah]

You could use, in M10:M16

=(K10-C10)-(F10-D10)-(J10-H10)

with custom format:
h "Hrs" mm "Min"

L10:
=M10*24, formatted as decimal

M18:
=SUM(M10:M16)
custom format:
[h] "Hrs" mm "Min Total for week"

[Quisp]

Thank you all for your insight. This was an old spreadsheet done on my first accounting internship years ago in the 90's, originally using Quattro Pro(Borland). I hadnt recalled the calc error before. I ended up using protonLeahs suggestion, as it simplified it with desired result. Thanks again