Forum Discussion

timazarj's avatar
timazarj
Icon for Helper II rankHelper II
5 years ago

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.  
Need Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

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's avatar
timazarj
Icon for Helper II rankHelper II
5 years ago

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