Got it!! It works! Thanks. Dick
Ross Johnson wrote:
On Fri, 2006-04-07 at 14:30 -0400, Richard Connors wrote:
I'm using ver 2.0.2 and need to get the difference between two times
converted into a decimal, not a time format, ie, I want an hour and a
half expressed not as 1:30, but as 1.50. Can't figure this out.
Time is stored internally as a fraction of 1 day. So 24 hours is 1.0
days. This allows Date+TimeOfDay to be stored as a single floating point
value.
So to convert a Time of 1:30 (hr:min) to decimal, multiply by 24 and
format as a decimal value (but not Number/General).
E.g.
If cells A1 and A2 are Time format, and cell A3 is Number/-1234.12
format contains the formula "=(A1-A2)*24", I get:
A1 A2 A3
2:00 0:30 1.50
Regards.
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
