I would like to know if it’s possible to create a column type of durations or timecodes (at least hours, minutes and seconds). I work in a TV channel and for us it’s important to have such a type of column that would allow us to have the sum and average of all the values in that column (durations).
The alternative for what we want is to use the formulas to convert a duration to seconds and then manually put the sum of seconds on the last line (‘SEG’ column).
Formula of the ‘-’ column:
Formula of the ‘DURATION’ column:
Please let me know if you need any further information.