Bug 74426 - EDITING: Enhancement: add functions which converts days into min, hrs, sec
Summary: EDITING: Enhancement: add functions which converts days into min, hrs, sec
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2014-02-03 05:54 UTC by bugquestcontri
Modified: 2014-02-08 08:11 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2014-02-03 05:54:07 UTC
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: release
Comment 1 Dominique Boutry 2014-02-03 13:50:48 UTC

W_Whalley gave the best response (=B1*1440/A1), with an explanation. Not really cumbersome. Is it worth a new native function ? IMHO I think not.

Anyway, Not A Bug.
Comment 2 bugquestcontri 2014-02-04 13:58:17 UTC
Hi Dominique,

For all the people who know the "1440" it is not very difficult to make the sample calculation. But who knows the "1440"? I personally hope that I don't forget this figure. Thinking about the possibility to make 3 simple functions based on w-whalley's great advice in AskLibO I wrote this enhancement request.

Maybe it could be considered as an easy-hack. I am unfortunately not able to write source code, otherwise I would take up this task myself.
Comment 3 Dominique Boutry 2014-02-05 13:30:16 UTC
Thank you for your answer.

Next time, I'll write (24*60) instead of 1440, it's more debugable. And if ever I have to use the number os seconds per day, I promise to write (24*60*60) and not directly 86400 ;-)
Comment 4 bugquestcontri 2014-02-07 11:34:04 UTC
HI Dominique, it seems to me that you are a member of this strange species of people you can multiply figures.... even without electronic calculators.... ;-)