cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Amirbeg New Member
New Member

Calculate Time SPent

I need simple calculation on time spent on different projects.

All of them are done on the same day. I need to know how much time was spent for each line. 

I am importing excel spreadsheet where this is calculated correctly, but after I import to Power BI it is useless. I have to create a calculated column with the following calculation:

 

[Time Completed]-[Time Started]

 

Here is when all confusion starts. How to format these values to show me if project lasted 15 minutes or 1 hour 20 minutes and so on. Instead I have something like

0.416666667

Especially when I calculate total hours it gives me value like 0.88 which is not right. I would like to see, when I select on slicer one week, to give me something like 9 hours and 45 minutes. How can I accomplish this in Power Bi? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Calculate Time SPent

@Amirbeg,

 

You may use the FORMAT Function.

https://community.powerbi.com/t5/Desktop/Transform-minutes-to-hour-using-filters/m-p/193760#M85262

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Calculate Time SPent

@Amirbeg,

 

You may use the FORMAT Function.

https://community.powerbi.com/t5/Desktop/Transform-minutes-to-hour-using-filters/m-p/193760#M85262

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.