Time format

[shantupm5]

Hello,

I have a time format in data set to which is avg of turn around time. Which is also >24 hrs.

How can i format it to >24 hrs, which is available in MS Excel (37:30:55)

I dont see similar format in Power BI, also when i transform the data, the time number changes for anything >24 Hrs. (For example, Actual TAT is 185:45:00, while uploded to PBI, the same data set changes to 17: 48:00)

[Anonymous]

Hi @shantupm5 ,

It doesn't exist over 24 hours of time format in Power Query.

Well, you could change the type as text format.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[shantupm5]

Hi Stephen,

I need to performe other calculations basis the result i get. but i suppose we cant write measures on text format.

Advice

Prashanth