Totalling the durations recorded in my table

Query functions accept custom Clojure functions for arbitrary calculations on the results of the query. It needs some coding, but it is totally possible:

  • convert all formatted times to seconds
  • calculate their sum
  • convert the sum back to formatted time

The same approach is possible through advanced queries. A solution for unformatted time is here.