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: 188.8.131.52 release
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.
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.... ;-)