Converting Seconds to Time format

[paulrit]

HI,

Can anybody help me with a formula which can convert seconds to hh:mm:ss format. If I devide seconds by 3600, I am not getting the correct result.

Thanks in advance.

Paul

 

[GlennUK]

You have to divide by 24 too, like:

=A1/60/60/24

 

[paulrit]

No, I am not getting as expected. I have 3722 seconds, I am looking for a formula which results (hh:mm:ss) 01:02:02.

Any help please.

Paul

 

[Ruddles]

What are you getting? 0.043? Have you formatted the cell as Time?