Ask Your Question

Revision history [back]

LibreOffice, OpenOffice, Excel, etc., do NOT calculate times as hours, minutes, and seconds.

You have to convert them to fractions of a day or use the format string for elapsed time.

So, your 1:10:36 works out to 0.0490277777777778 days.

Your 58:20 is 0.0405092592592593 days.

For example, running 5 miles in 00:58:20 should be 5/0.0405092592592593/24 to give you 5.1428571429 miles per hour

Add /24 at the end of your formula