Calculate Time SPent

[Amirbeg]

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? 

[v-chuncz-msft · Accepted solution]

@Amirbeg,

You may use the FORMAT Function.

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