Convert time to seconds (Time is in >24 hours fomat - 45:45:00 Hrs)

[shantupm5]

Hello,

Do we have any workaround to convert the below time format to exact seconds

The Time is in >24 hours fomat - 45:45:00 Hrs.

Prashanth

[Ahmedx]

[shantupm5]

Hello,

In power query, i have it as Duration and in Data Modal,  have changed it to Time format (HH:MM:SS).

Issue here is that i have the time ranging which is >24 hrs. When i load the data to Power BI, the numbers are chaning. I have attached the screen shot below. Higlighted in red (which is greater then 24 hrs changes in Power BI)

[Ahmedx · Accepted solution]

in powe query

[Ahmedx]

so that the time does not change in the model, you need to convert it to text( in power query)

[Ahmedx]

you 45:45:00 Hrs. a text column?