AverageIFS equivalent

[TWE_Toll]

Hi,

I have a column called [Gate to Gate Time] which subtracts [Finish]-[Start]. Type is set to “duration” as per appsheet requirements.

I have a virtual column called [Gate to Gate Average] which i need to return the average [Gate to Gate Time] if the date is today() and the [Gate to Gate Time] cell is not empty (Average time not including 0).

I have tried the average functions i can find in the forums however due to the [Gate to Gate Time] being set to type “duration” it is returning and error. If i change the type “duration” to “time” i get an error with the [Finish]-[Start].

Thanks for your help.

Tim