Time format not getting correct in Custom Column at Edit Queries window

[avulasandeep]

HI Developers , 

i got one error in edit queries when i create custom column  seconds  to Time format  as below.

This column is in seconds

I used this below formula in custom column  

and Finally i am getting output as like

but i need output as below format 

can anyone know correct format formula   for Seconds to  HH:MM:SS format 

Thanks 

Sandeep 

9441181581

[v-qiuyu-msft · Accepted solution]

Hi @avulasandeep,

In Query Editor, we are not able to format Time values in different format. After we load the data to data model, we can change format below: 

Best Regards,
Qiuyun Yu