Convert seconds into hh:mm:ss format

[bindu_apte]

hi All,

I have a requirement where in i should display time in hh:mm:ss format and the field is in seconds, when i try using the below expression

Time(Time#(fieldname,'ss'),'hh:mm:ss'), am not getting correct value.

In precise, if the value is more than 24hours, it is not considering. It is subtracting from 24hours and rest is displayed i believe.

Ex:120720s it should give (33:32:00) instead it is giving 9:32:00

Please come up with the correct expression and explaination.

Thanka in advance,

Bindu

[amit_saini]

Hi Bindu,

Please try this:

Go to chart properties-:> Number-> select Time option and here you can change the format.

Thanks,
AS

[ashfaq_haseeb · Accepted solution]

Hi,

try the below code.

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

Regards

ASHFAQ

[bindu_apte]

Hi,

Thanks for your reply.

In our dashboard we are using the field as a dimension not in expression.

If we are using in expression and changing the format under number we are getting wrong value.

Thanks

[bindu_apte]

Thanks Ashfaq,

Its working 🙂

[#6]

Having this exact issue and happy to find the correct answer here Thanks Ashfaq!