View Single Post
  #7   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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LBaker" wrote in message
...
Thank you so much.....I got several replies, however, yours was the only
one
that actually produced the correct results. Gold star to you!

"T. Valko" wrote:

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!