Format Cells for time

J

Jas2be

I have a list of time values in seconds. I would like the
seconds to be converted into a decimal format.

Example
..30 seconds to be .5
..45 seconds to be .75
..15 seconds to be .25

Is there a format option to accomplish this?

Thank you,
Jason
 
P

Peo Sjoblom

If they are time values and .30 seconds is 30 seconds, then you can use

=A1*24*60

or

A1*1440

format as general

if it is 0.3 as a decimal value

=(A1/864)*1440
 
Top