Just when I think this spreadsheet is working, I find something slightly
There are 2 "totals" cells. The first totals cell shows total exact time,
the other shows it rounded down. The complex rounding down formula I got
several weeks ago does the rounding bit but doesn't show total time
correctly. I didn't have enough hours until now for this to show up. After
24 hours, it subtracts 24 and just shows time as if it were a clock time
(i.e., rather than 25 hours, it shows 01h00, as if it were 1 o'clock a.m.
instead of a sum of 25 hours). Anywho, the initial rounding formula doesn't
let [h]:mm work, but the regular rounding one I recvd yesterday in the group
allows [h]:mm to work perfectly but isn't rounding down, just rounding in
general. In the example below, it is rounding _UP_ 2 minutes.
i.e., the real total in the test hours I plugged in
shows these results:
while the cell that rounds shows:
As this is talking about overtime, this is not good. I need it to round
down but hopefully just to closest five minutes. I don't want to get paid
for 2 extra minutes because that would freak out the overtime people
eventually <g>, but rounding down to 72h55m, for example, would be perfectly
fine. I'd lose out on 3 minutes of overtime but this way, no problems with
Is there a way to get the formula, which is in this particular case is:
to round DOWN to nearest 5 minutes?
Hopefully the cell format of [h]:mm will still work, too.
Thanks so much! Eventually this darn sheet will work
and I will be able to
share it with the rest of the floor here! :oD