Re: How to get hours from hh:mm

[J. David Boyd]

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.