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!

 

[David Biddulph]

Multiply by 24, and format as General or Number.

 

[T. Valko]

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

 

[Mike H]

Hi,

Multiply the time by 24 and format as general

Mike

 

[FSt1]

see your other post in general.

FSt1

 

[LBaker]

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]

You're welcome. Thanks for the feedback!