Forum Discussion
Duration 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.
5 Replies
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.
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
It is the amount that an employee was not ready to take customer phone calls in a month.
When I transform it into Power Query, it showed it as date/time, and I change it to time. then in Power bi, I change the format to HH:MM:SS
