Re: How to get hours from hh:mm

[Pascal Bourguignon]

david@adboyd.com (J. David Boyd) writes:

> Cecil Westerhof <dummy@dummy.nl> writes:
>
>> Pascal Bourguignon wrote:
>>
>>> Cecil Westerhof <dummy@dummy.nl> writes:
>>> 
>>>> I have a table in org-mode with time needed to travel from A to B an the
>>>> number of km. I would like to get the average speed. How do I convert a
>>>> time? For example 0:45 becomes 0.75.
>>> 
>>> How do you know that 0:45 becomes 0.75?
>>> 
>>> How did you do it?
>>
>> I did not. I want. 0:45 is three quarters of an hour, so in mathematical
>> notation 0.75.
>> What I would like:
>> - the first field contains 90
>> - the second field contains 0:45, or 00:45
>> - the third field is computed to 120
>
> It is based on dividing by 60.
>
> 0:45 is 45 minutes, which is 45/60 of an hour.
>
> This becomes .75.

You need to unlock Cecil's neurons!  He clearly knows it, but he
doesn't know that he knows it.


-- 
__Pascal Bourguignon__                     http://www.informatimago.com/

NOTE: The most fundamental particles in this product are held
together by a "gluing" force about which little is currently known
and whose adhesive power can therefore not be permanently
guaranteed.