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]
