ericet
1
Hello Everyone,

I’m trying add hours per day together to find the total hours

Example:

Monday 8 hours

Tuesday 7 hours

Wednesday 10 hours

Total hours 25 hours

I’m looking in the Learning Center did not find anythng.

It would be great to have something about time calculations.

Here is my Power BI File and screen shot

I’m trying to get the total hours for Customer A, B, C, D

Duration.pbix (22.2 KB)

ericet
2
As you can see Duration Sum is incorrect. How do I do this ?

ericet
3
Here is the CSV Data if you need it.

DurationSampleData.csv (3.0 KB)

Hi @ericet

I believe it’s because of how time values are represented behind the scenes, so when you sum them it doesn’t give what you’d expect.

I made a measure that converts your time into a decimal e.g. 07:30:00 showing as 7.5:

```
Duration Hour Minute =
//Find hour of time
VAR _Hour = HOUR( SELECTEDVALUE( DurationSampleData[Duration] ) )
//Find minute as proportion of hour
VAR _Minute = DIVIDE(MINUTE( SELECTEDVALUE( DurationSampleData[Duration] ) ), 60, 0 )
//Add together
VAR _Result = _Hour + _Minute
RETURN
_Result
```

Then a measure to sum it up:

`Duration Sum v2 = SUMX( DurationSampleData, DurationSampleData[Duration Hour Minute] )`

That gave the below:

Duration.pbix (22.7 KB)

3 Likes

ericet
5
Yes, thank you so much !

That solved my problem, and will help others I’m sure.

Thanks again