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
Hi ,
Please explore the below mentioned workaround.
You may wish to modify the [Gate to Gate Time] columnโs expression to TOTALHOURS([Finish]-[Start])
With this modified expression you should be able to apply AVERAGE() on a list of [Gate to Gate Time] column duration values, now converted to decimal base.
Things to note:
Great explanation, @Suvrutt_Gurjar! This is a quality post.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |