Need a formula for time conversion
 

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!

Need a formula for time conversion
 

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!

Need a formula for time conversion
 

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!

Need a formula for time conversion
 

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!

Need a formula for time conversion
 

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!

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!

Need a formula for time conversion
 

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!