Convert value to decimal

[Steved]

Hello from Steved

I would like to covert value 36300 (seconds) to 6.05

Thanks in advance

 

[Ozzie]

=+A1/6000

 

[Kent]

Converting seconds to minutes:

=CONVERT(A1,"sec","mn") would be 605 so I guess based on
your question =CONVERT(A1,"sec","mn")/100 is 6.05

[email protected]
-----------------------------------------------------------

 

[Steved]

Cheers

-----Original Message-----
=+A1/6000


.