I have a sum of a list of durations and a count of how many rows.
Could do with an accurate average but my calculation is rounding the numbers??
[list of durations] (Duration)= 0:11:10
[count of elements] (Number) = 4
[Average] (Decimal) =
totalseconds([list of durations])/[count of element]/60
The result = 02.00
where really I could do with it being more accurate as: 00:02:48
Would any of the Appsheet gurus have any ideas?