Need a formula for time conversion

  • Thread starter Thread starter LBaker
  • Start date Start date
L

LBaker

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!
 
If you have actual times, you can simply multiply by 24 and format the
result as numeric, not time.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Thank you but this didn't work.

I used the example below of 59 minutes -- reported as :59 in column a --
it needs to show up as 0.98 in column b

with the formula below, it comes up #VALUE!

If I try it with 1 hour and 59 minutes reported as 1:59, it comes up 119.00
 
If you have actual times, you can simply multiply by 24 and format the
result as numeric, not time.
Click to expand...

For example, I put
=TIME(1,59,0) in A2
and =A2*24 in B2
and formatted B2 as a number to obtain 1.98.

If you get something else, maybe A2 isn't an "actual time" but something
else that looks the same.
 
hi
sorry i got confused.
chip's formula should have worked foryou.
if you are getting a value error, your times may not be formated as time.

Regards
FSt1
 
Hi,

I think you have gotten hooked on the first response, which was an error you
should just multiple by 24, not by 24*60.

Let me assure you the answers you are getting are correct 24 times a entry
of 0:59 will return 0.98333

If you are not getting those results the problem is not in the responses but
in the content of your spreadsheets values in column A.

So just to verify you data in column A, for example A1 is

0:59 and if you look at the Formula Bar you should see 12:59:00 AM

If not, then tell us what you see.
 
Back
Top