Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
timazarj
Helper II
Helper II

Duration time format

The below excel data is import to Power bI.

timazarj_0-1620845347172.png

but when I check it in power bI I see below:

timazarj_1-1620845448350.png

 I need to calculate the Not-Ready percentage. please advise me.

 

5 REPLIES 5
selimovd
Super User
Super User

Hey @timazarj ,

 

what exactly does "178:53:03" mean?

And what format did you give to the column in Power Query?

 

Best regads

Denis

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

 

@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-....

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.






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



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 regards
Denis
 

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:

timazarj_0-1621014226672.png

timazarj_2-1621014305944.png

 

timazarj_1-1621014257057.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.