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)

On Fri, 13 Feb 2009 13:46:30 -0800, LBaker
wrote:

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!

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

Regards
FSt1

"LBaker" wrote:

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!

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



"FSt1" wrote:

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

Regards
FSt1

"LBaker" wrote:

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!

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

"Chip Pearson" wrote:


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)

On Fri, 13 Feb 2009 13:46:30 -0800, LBaker
wrote:

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.

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

"LBaker" wrote:

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



"FSt1" wrote:

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

Regards
FSt1

"LBaker" wrote:

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!

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"LBaker" wrote:

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!

In which case you don't have an actual Excel time. If you used :59, Excel
would probably treat it as text. Use 0:59, and then Chip's formula will
work. If you have many numbers that have been wrongly entered, you can cope
with =(IF(LEFT(A1)=":",0,"")&A1)*24
--
David Biddulph

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

"Chip Pearson" wrote:


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)

On Fri, 13 Feb 2009 13:46:30 -0800, LBaker
wrote:

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!