Post

2 followers Follow
0
Avatar

Sum of duration fields

I have some basic problems summing relation fields up.

Can anyone tell me why i'm able to sum the number if it's nested within a numbers field, but not if it's nested within a duration field? https://screencast.com/t/KYkeaDYYk

Kasper Dam

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Kasper,

when you calculate the the sum with @sum of duration field the result is always in hours (also if you do: @duration field).
Example: 
duration 1 = 15 Min
duration 2 = 30 Min

result of @sum of duration = 0,75 (hours)

If you want the result to be shown as minutes

@sum of duration * 60

result: 45 min

Rainer

 

Rainer Grabowski 0 votes