Need a formula for time conversion

[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!

 

[Chip Pearson]

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)

 

[FSt1]

hi
say your time is in column A.
=A2*60*24
format as general or number.

Regards
FSt1

 

[LBaker]

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

 

[LBaker]

I just tried this with the example I used below and it doesn't work

 

[MyVeryOwnSelf]

If you have actual times, you can simply multiply by 24 and format the

result as numeric, not time.

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.

 

[FSt1]

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

 

[Shane Devenshire]

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.