Thread: Formatting numeric value to time

Hello and happy new year to you all...

I have a question regarding formatting excel cells in a time format. More specifically:

I we have in cell A1 the value of 346 and assume that these are seconds, how can we easily convert this value to a "00:05:46" format? What I do now is find the quotient of 346/60 (=5) and then the rest of the seconds (=46). But then I need to type manually the 00:05:46 cell.

I didn't find any solution in format cells -> custom.
I would be grateful for any help on this.

Thanks

If you have 346 in the cell and the format is general then you can't do that with formatting.

Excel regards 346 as 346 days so to convert to seconds you can use a formula in another cell that divides that number by the number of seconds in a day (86400), e.g. in B1

=A1/86400

and format B1 as [hh]:mm:ss

Thanks for both replies. It seems that the time function does the job... after adjusting for the correct hh:mm:ss format. Thanks again.

John