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
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.
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.
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 ;-)
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.... ;-)