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
- Press the + after the last field.
- Choose Timer.
- Choose how the time shows when stopped: h:mm or h:mm:ss.
- 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} / 60minutes. 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.