Forum Discussion
timazarj
Helper II
Helper IIDuration time format
The below excel data is import to Power bI. but when I check it in power bI I see below: I need to calculate the Not-Ready percentage. please advise me.
selimovd
Most Valuable Professional
Most Valuable ProfessionalHey timazarj ,
what exactly does "178:53:03" mean?
And what format did you give to the column in Power Query?
Best regads
Denis
ChrisMendoza
Resident Rockstar
Resident Rockstarselimovd - It should be representing 'elapsed time in hours' as shown at https://support.microsoft.com/en-us/office/format-numbers-as-dates-or-times-418bd3fe-0577-47c8-8caa-b4d30c528309.
I'm curious how Power BI or Power Query is displaying this because I can't seem to change the type to anything other than text.