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!

Multiply by 24, and format as General or Number.
--
David Biddulph

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

Hi,

Multiply the time by 24 and format as general

Mike

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

see your other post in general.

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

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!