help-gnu-emacs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: How to get hours from hh:mm


From: J. David Boyd
Subject: Re: How to get hours from hh:mm
Date: Thu, 14 Jun 2007 16:15:39 -0400
User-agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1.50 (gnu/linux)

Cecil Westerhof <address@hidden> writes:

> Pascal Bourguignon wrote:
>
>> Cecil Westerhof <address@hidden> 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.






reply via email to

[Prev in Thread] Current Thread [Next in Thread]