Convert Seconds into hhh:mm:ss?

[DarrenF]

Is it possible to convert 323584 seconds into Hours, Minute, Seconds?

 

[Rick Rothstein]

Something like this maybe...

=TEXT(A1/86400,"[h] ""hours"" m ""minutes"" s ""seconds""")

 

[jtakw]

Hi,

Or just do the math, and format the cell:

Book1
	A	B	C
1	323584		89:53:04
2			Formatted [h]:mm:ss
Sheet128

Cell Formulas
Range	Formula
C1	=A1/86400