https://bugs.freedesktop.org/show_bug.cgi?id=74426
Priority: medium
Bug ID: 74426
Assignee: [email protected]
Summary: EDITING: Enhancement: add functions which converts
days into min, hrs, sec
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.4.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Time calculations are bit cumbersome. When you have to calculate e.g the speed
of an moving object and time is given in hh:mm:ss format. Before you can
divide a distance by the time you need to convert the time in a format that the
division can be made.
Currently there are two ways:
1 - =(HOUR(B1)*60+MINUTE(B1)+SECOND(B1)/60)
2 - =B1*1440 (published by w_whalley)
where B1 contains the time in hh:mm:ss format.
Based on the simplicity of w_wahlley's approach I am writing this enhancement
request. See also :
http://ask.libreoffice.org/en/question/29240/how-to-calculate-minutes-per-kilometer/?answer=29244#post-id-29244
Operating System: All
Version: 4.1.4.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
