Assuming the number of seconds is in A1,

=A1/86400


Then, format the cell as custom "hh:mm:ss"



"dharmender mehra" wrote:

What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in
hrs:minutes:seconds) format?