Duration time format

[timazarj]

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]

Hey @timazarj ,

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

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

Best regads

Denis

[timazarj]

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

[ChrisMendoza]

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

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

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[timazarj]

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: