# Issue with calc hours with mins converting to hours with decimal

the value reads 48.233 when value should be 48.25

Why would 15 mins account for 0.5 of an hour ? , 15 mins are a quarter therefor 0.25 take a few seconds off and you have 0.233

Should be 48.25, really, not 48.50.

48,233 is around 1 minute off. Looks like rounding error to me. Most likely, the times recorded are not exactly on the minute mark as displayed.

Instead of extracting days, hours and minutes to build the hour total, you could just use `=H5*24` and format explicitly as decimal.

To eliminate the rounding error, try rounding in the H5 formula:
`=MROUND(G5-F5;1/1440)`.

eliminate the rounding error, try rounding in the H5 formula

Not sure what is this trying to achieve. The time difference (duration), if formatted properly, has one of duration formats like `[HH]:MM`, with square brackets meaning not only “do not divide modulo 24”, but also “round the result to the least shown part”. This gives “15 minutes” for durations ending with e.g. “14 minutes 48 seconds”, unlike in truncating “wall clock” formats `HH:MM`, which give “14 minutes” for times ending with “14 minutes 48 seconds”. Where the rounding is needed is IMO in `I5`.

This worked out. Thank you so much.

would suspect rounding in H5 is ‘for display only’ and the value taken for downstream calculations has some deviation,

formula applied to a ‘keyed-in’ value of 48:15 works correctly,

would like to have formula or ‘real value’ of I5 …

assume calculated from ‘G5-F5’? subtraction of similar values, operands ‘big’ relative to ‘small’ result → ‘cancellation’, tried, couldn’t repro, and res. should be rather too big than too small? inaccurate date-time values? old calc ver. with calculation errors?

just tried keyed-in values between 48:14:59,50 and 48:14:59,99 formatted to [HH]:MM, effect as in OP

48:14:59,49 is rounded to a display of 48:14 … understand who wants …

P.S. ‘solved marks’ and ‘likes’ welcome,
click the grey circled hook - ✓ - top left to the answer to turn it green if the problem is solved,
click the “^” above it if you ‘like’ the answer,
“v” if you don’t,
Date and time formats always display -whatever they display at all- rounded down, and this is constitutive for their functionality. Remember: they are made for points in flowing time with an exactly specified `time zero` (1899-12-30 00:00:00). What would you tell me if I made display a cell formatted `DDDD` “Tuesday” if the value is `44250.49866872690`, but “Wednesday” for a value of `44250.5012800110`? To show “Tuesday” in both cases is the way calendars work, and basically in the same way work time-pieces, if “digitalized” at all.