[Top][All Lists]

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

Re: How to get hours from hh:mm

From: Pascal Bourguignon
Subject: Re: How to get hours from hh:mm
Date: Fri, 15 Jun 2007 07:52:57 +0200
User-agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.1.50 (gnu/linux)

address@hidden (J. David Boyd) writes:

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

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

__Pascal Bourguignon__           

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

reply via email to

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