View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Need a formula for time conversion

If you're entering a whole number:

A1 = 59

=A1/60

If you're entering as a time:

A1 = 0:59

=A1*1440/60

Format as General or Number

--
Biff
Microsoft Excel MVP


"LBaker" wrote in message
...
I need a formula that will convert length of time from a 60 minute base to
a
decimal using tenths (2 decimal places).

For example: 59 minutes is reported as :59, but I need that to be
converted
to 0.98

Any help would be appreciated. Thanks!