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