Time conversion 1

[bacalaoyalcapurria]

Is there a way to change this numbers to hh:mm:ss?


These are seconds
292
29
54
286
57840

I'd like to create a column next to the "seconds" column and have Excel to convert the above seconds to hour-minutes-seconds. "00:00:00"

Thanks,

Rita

 

[xlhelp]

=[cell to the left]/86400
and then format it to time, using Format Cells.

 

[bacalaoyalcapurria]

Thanks but I did that before.

If I have this many seconds

257880/ 86400 = 2.984722222
but when I format it using Format Cells I get 23:38

That's not right
Is there a way to get the right number. It sure is more than 23 hours.

Thanks,

Rita

 

[xlhelp]

You would need to go to Format Cells dialog box. Under NUmber tab, choose Time and the Custom. In the Type: box enter [h]:mm:ss

 

[bacalaoyalcapurria]

Thank you so much. You guys are the best.