Forum Discussion
Helper IIDuration time format
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
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.
- selimovd
Hey ChrisMendoza and timazarj ,
that makes sense. But Power BI doesn't have that format.
If you use Time as data type, then Power Query wants to transform that value to a proper time why you got that result.
This means you have to convert the column to the amount of hours or minutes or seconds. I would do that already in Excel and convert it to "Elapsed time in seconds [ss]". This you can still divide by 60 or 3600 to get minutes or hours in Power BI.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
timazarjThank you, I tried and it worked, but I did the second conversion manually, tried to use the functions but didn't work. I need to come up with a formula to do the conversion in excel otherwise it will be time-consuming. I need it for a weekly meeting. any suggestion in excel: