Forum Discussion
Duration time format
selimovd - 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.
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.
Thank 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:
