Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

Timer field: start and stop a timer

Updated

A Timer field counts the time spent on a record, such as a task or a time entry. Press the start button when you begin and the stop button when you are done. While it runs, the cell shows the time ticking to the second; when it stops, the time is added to what the record counted before, so a task worked on in several sittings adds up.

Add one

  1. Press the + after the last field.
  2. Choose Timer.
  3. Choose how the time shows when stopped: h:mm or h:mm:ss.
  4. Type a Name and press Create field.

Start and stop

  • Press the round button in the cell: it starts the timer, turns into a stop button and the time starts to tick.
  • Press it again to stop. The run is added to the total.
  • With the cell selected, Space or Enter starts or stops it too, and so does the button in an open record.
  • A running timer keeps running when you close the page: the record keeps when it started, so it shows the same time on your phone, on a colleague's screen and after a reload.

Type a time instead

Forgot to start it? Select the cell and type the time, such as 1:30, 45m or 1h 30m, then press Enter. The typed time replaces what was counted, and a running timer stops. In a form the Timer field is a box to type the time in.

Use the time

  • Formulas read a Timer field in seconds: ROUND({Timer} / 3600, 2) gives hours with two decimals, and {Timer} / 60 minutes. A running timer counts the time so far.
  • Rollups add timers up across linked records, such as all the time spent on a project.
  • Sums at the foot of a column, pivots and charts add timers up like durations. Sorting and filtering read the time as a number.
  • Exports and copies write the time as h:mm:ss.

Good to know

  • Only the base's owners add fields. Anyone who may edit records starts and stops timers, and each start and stop is in the record's history and can be undone.
  • The Time tracking template has a Timer on every time entry, with hours, billable hours and what to bill worked out from it.
  • Through the API a timer is a number of seconds, or {"total": seconds, "since": "an ISO time"} while it runs. You can also send "1:30" or "45m".
  • A Duration field holds a length of time you type; a Timer field counts it for you.

Related