 | 1 | initial version |
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
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
