Need a formula for time conversion
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!
|