Microsoft Office Forums - View Single Post - Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets)

gluonman · 03-22-2017, 04:58 PM

Quote:

That's fine.
It may not at all be a problem, but be aware that your preferred solution doesn't allow for times to cross midnight (for example 2200, 2300 2330 and 130 in A1, B1, C1 and D1 respectively).
(and the decimal values problem is just to multiply the value in K9 with 24 and format K9 as General).

Thanks for the additional tip. I had failed to consider that case, and turns out that will be a problem for me, so I'm going to see about modifying my solution a bit more to account for that.