Bug 74426 - EDITING: Enhancement: add functions which converts days into min, hrs, sec
EDITING: Enhancement: add functions which converts days into min, hrs, sec
 Status: RESOLVED NOTABUG None LibreOffice Unclassified Calc (show other bugs) 4.1.4.2 release Other All medium normal Not Assigned BSA

 Reported: 2014-02-03 05:54 UTC by bugquestcontri 2014-02-08 08:11 UTC (History) 0 users

Attachments

 Note You need to log in before you can comment on or make changes to this bug.
 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: 4.1.4.2 release``` Dominique Boutry 2014-02-03 13:50:48 UTC ```Hi, 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.``` 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.``` 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 ;-)``` 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.... ;-)`