Can a form add up times or work out totals automatically?

Turn on Calculation, under More options in the form question settings, to add up time or number fields, a whole section, the time between two times, or a formula; it is shown as hours and minutes or a number.

Quick answer1 min readUpdated for AveeCare
Short answer

Yes. In the form builder, select the question that should hold the total, open More options at the bottom of its settings and turn on Calculation. Choose Add answers together (pick the answers, or Add a whole section), Time between two answers for a start and an end time, or Write a formula. Choose Show as Hours and minutes or Number. Nobody types it; it updates as the form is filled.

Step by step

  1. Open the form in the form builder.
  2. Add or select the question for the total.
  3. Open More options in its settings and turn on Calculation.
  4. Choose Add answers together, Time between two answers or Write a formula, and pick the questions it uses.
  5. Choose Show as, then save the form.

Good to know

  • Plain numbers in a time total count as minutes, and entries like 1:15 count as hours and minutes.
  • Formulas can use + - x / and SUM, MIN, MAX, ROUND, BETWEEN and AVERAGE. A question name goes in square brackets.
  • Office forms Calculation is for forms your office fills. Public intake forms keep plain boxes.
Written by
Founding Partner, AveeCare

Builds AveeCare full-time. The AveeCare Help Center is written and maintained by the team that builds the product, so the steps in every article come from the same people who ship the features.