The latest field type, duration, is now live! It’s designed to store time durations measured in hours, minutes, seconds, or milliseconds. There are five different formatting options:
- h:mm - for hours and minutes, e.g. 1:23
- h
ss - for minutes and seconds, e.g. 3:45, or hours, minutes, and seconds, such as 1:23:40 - hss.s - for minutes, seconds, and deciseconds, e.g. 3:45.6, or hours, minutes, seconds, and deciseconds, such as 1:23:40.0
- hss.ss - for minutes, seconds, and centiseconds, e.g. 3:45.67, or hours, minutes, seconds, and centiseconds, such as 1:23:40.00
- hss.sss - for minutes, seconds, and milliseconds, e.g. 3:45.678, or hours, minutes, seconds, and milliseconds, such as 1:23:40.000
You can also now format the output of computed fields as durations, and use durations in formula fields. You can read more about it here.
