Duration

  • Updated

The Duration data type mceclip1.png is for representing a period of time (e.g., the number of days elapsed between starting and ending dates). Durations may be calculated off of other Date cells, Date & time cells, or data and formula inputted into a Duration cell.

mceclip0.png

Duration data types can be used to show the time elapsed between a task's beginning and ending, to calculate the time remaining before upcoming deadlines, or used to figure out how quickly bugs need to be eliminated to hit your go-live date. Duration isn't just time elapsed between two dates or times, but can be calculated using any formula.

Calculating Duration

To calculate duration between multiple dates, you will need to input a formula into the column, cell, or range of cells you would like to calculate the duration for. For instance, in the animation below, to calculate the duration between a bug was submitted versus when it was fixed, we set the column's data type to duration, then add the formula "=F2-E2" into the duration column, and drag this too the remaining cells in that column. You can use any other desired formula to calculate duration as well.

Duration.gif

Strict

Like other data types, Duration data types can have Strict enabled. Selecting the Strict checkbox for Duration cells will restrict users to input only numeric characters representation date or time durations. This means that formulas to calculate duration will need to inputted before setting Strict or the outputs of cells will need to be copy and pasted into duration cells. 

Note: Currently, formulas are not allowed in Strict Duration cells. When there are existing formulas in a column, cell, or range of cells and you change to strict, those formulas will be converted to the output value. You can always revert by selecting undo in the toolbar mceclip0.png or with the keyboard shortcut Ctrl + Z (CMD + Z for Mac users).

Format

Like Date data types, Duration data types have a number of custom formatting options. Shown below, these options allow you to display duration in days (2d), hours (1d 13h), or down to the second (37:26:24).

mceclip2.png

Duration data types often utilize Date or Date & time data type. Check out our articles on those articles or our articles on formulas for more ways to calculate durations.