Sum of duration fields

Follow

Kasper Dam

• January 11, 2018 11:14

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

0

• 

  Rainer Grabowski

  • January 14, 2018 15:16
  • Edited

  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

   

  0

  Comment actions Permalink

Please sign in to leave a comment.