Forum Discussion

avulasandeep's avatar
avulasandeep
Helper III
8 years ago
Solved

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

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

Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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 

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    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