How to convert Duration in seconds to HH:MM:SS?

[shannoypaul]

I have a column with data only in seconds for e.g. 5402s
This I want to split it as 01:30:02 i.e 1 Hour 30 Minutes 2 Seconds.

Thanks in advance!

Best Regards,

Shannoy

[ashfaq_haseeb · Accepted solution]

Hi,

Try like this

=interval(timestamp#(5402, 's'), 'hh:mm:ss')

Regards

ASHFAQ

[Anonymous]

=Time(5402/24/60/60,'hh:mm:ss')

[MarcoWedel]

=Interval(5402/86400)