group aggregate sum duration

[Vins]

hello, I am creating an app, I have a virtual column which is the result of entry and entry time. Obviously of duration. When I try to set group aggregate: sum columns duration, I find only NONE and COUNT. WHY can't I find sum column duration?
Thanks in advance

[Suvrutt_Gurjar · Accepted solution]

The time durations are a bit complex to sum unlike pure decimal entities because of uneven factors between hours, minutes, seconds conversions.. I believe that is why SUM option does not exist for duration expressions.

However AppSheet has three functions  (TOTALHOURS(), TOTALMINUTES() and TOTALSECONDS() ) that calculate duration in decimal values. So a duration of 4 hours 30 minutes would appear as 4.50 with TOTALHOURS() . You could thus calculate duration in decimal values with these functions and for these decimal duration columns , the SUM aggregate option should appear for grouping.

TOTALHOURS() - AppSheet Help