Time formats

Every field setting in the Forge version lets you pick one of 40 time formats. The format decides how the stored number of seconds is rendered in the custom field and in the Issue Navigator.

The same format catalogue is used by the Time Between Dates field settings.

The Time format list shows each format only as a sample - 13 hours 48 minutes 3 seconds, or a longer time for formats with days and larger units - for example 13h 48m 03s or 13:48:03 (HH:MM:SS). The list shows no format IDs. The IDs below (D0, DEFAULT, …) are the short names this page uses for the formats; the In the list column ties each ID to its label in the list.


Default format

D0 - 13h 48m 03s in the list - renders time as hours, minutes and seconds, for example 13h 53m 20s. Units that are zero are left out: an hour exactly is 1h, and zero is 0s. This is the built-in default of a new field setting.

DEFAULT is a separate format despite its name - 13:48:03 (HH:MM:SS) in the list, for example 13:53:20.


Format catalogue

The In the list column is the label you pick in the form. Examples in the table below assume a stored value of 50 000 seconds (13 hours 53 minutes 20 seconds, or roughly 0.58 days). Long-form examples further down the table use larger values to show how the format handles days, weeks, months, and years.

Seconds and minutes

In the list ID Example Notes
50000s D1 50000s Total seconds with s suffix
50000 D2 50000 Total seconds, bare number
833 D3 833 Total minutes, bare number
833m D4 833m Total minutes with m suffix

Hours

In the list ID Example Notes
13 D5 13 Whole hours, bare number
13h D6 13h Whole hours with h suffix
13.8 D7 13.8 Decimal hours, dot separator
13,8 D8 13,8 Decimal hours, comma separator
13.8h D9 13.8h Decimal hours with h suffix
13,8h D10 13,8h Decimal hours with h suffix, comma separator

Hours and minutes

In the list ID Example Notes
13:48:03 (HH:MM:SS) DEFAULT 13:53:20 HH:MM:SS
13h 48m 03s D0 13h 53m 20s Hours, minutes, seconds with suffixes; zero units are left out. The built-in default
13:48 D11 13:53 HH:MM
13h 48m D12 13h 53m Hours and minutes with suffixes

Auto

In the list ID Example Notes
860h 51m / 57m 50s (Auto) AUTO 13h 53m The two largest non-zero units of hours, minutes and seconds - see Auto format

Days

In the list ID Example Notes
10d D13 10d Whole days, d suffix
10 days D14 10 days Whole days, verbose
10d 15h D15 10d 15h Days and hours
10 days 15 hours D16 10 days 15 hours Days and hours, verbose

Weeks

In the list ID Example Notes
8w D18 8w Whole weeks
8 weeks D19 8 weeks Whole weeks, verbose
8w 6d D20 8w 6d Weeks and days
8 weeks 6 days D21 8 weeks 6 days Weeks and days, verbose
8w 6d 13h D23 8w 6d 13h Weeks, days, hours
8 weeks 6 days 13 hours D24 8 weeks 6 days 13 hours Weeks, days, hours, verbose

Months

In the list ID Example Notes
2m 3w D26 2M 3w Months and weeks
2 month 3 weeks D27 2 months 3 weeks Months and weeks, verbose
2m 3w 6d D29 2M 3w 6d Months, weeks, days
2 month 3 weeks 6 days D30 2 months 3 weeks 6 days Months, weeks, days, verbose

In the short forms, months are rendered with an uppercase M and minutes with a lowercase m - so 2M 3w is two months and 5m is five minutes.

Years

In the list ID Example Notes
1y 2m 3w D32 1y 2M 3w Years, months, weeks
1 year 2 month 3 weeks D33 1 year 2 months 3 weeks Verbose
1y 2m 3w 6d D35 1y 2M 3w 6d Years, months, weeks, days
1 year 2 month 3 weeks 6 days D36 1 year 2 months 3 weeks 6 days Verbose
1y 2m 3w 6d 13h D38 1y 2M 3w 6d 13h With hours
1 year 2 month 3 weeks 6 days 13 hours D39 1 year 2 months 3 weeks 6 days 13 hours Verbose
1y 2m 3w 6d 13h 5m D41 1y 2M 3w 6d 13h 5m With hours and minutes
1 year 2 month 3 weeks 6 days 13 hours 5 minutes D42 1 year 2 months 3 weeks 6 days 13 hours 5 minutes Verbose
1y 2M 3w 6d 13h 5m 7s D44 1y 2M 3w 6d 13h 5m 7s Full - years, months, weeks, days, hours, minutes, seconds
1 year 2 month 3 weeks 6 days 13 hours 5 minutes 7 seconds D45 1 year 2 months 3 weeks 6 days 13 hours 5 minutes 7 seconds Verbose full
1y 2MONTH 3w 6d 13h 5m 7s D46 1y 2MONTH 3w 6d 13h 5m 7s Uppercase month token

Auto format

AUTO picks the units from the value itself and shows the two largest of hours, minutes and seconds:

Value Shown as Examples
1 hour or more hours and minutes, like D12 860h 51m, 1h 05m, 3h
under 1 hour minutes and seconds 59m 27s, 1m 37s, 1m
under 1 minute seconds 37s, and 0s for zero

Seconds are visible exactly where short values are added up by hand, while long statuses stay compact. Days and weeks are never used: with a work calendar a day can be 8 hours, and 1d would read ambiguously. The hour is the calendar’s hour, the same as in the compound formats (see Unit calibration).


Choosing a format

  • Small time spans (under 24 hours): D11 (13:53), D12 (13h 53m), D0 (13h 53m 20s), or DEFAULT (13:53:20).
  • Values of any length, short and long: AUTO - seconds below an hour, hours and minutes above it.
  • SLA-style numeric comparisons and exports: D2 (50000), D1 (50000s), or D4 (833m). Bare numbers are easiest to aggregate in external BI tools.
  • Days or weeks-long values: D15 (10d 15h), D24 (8 weeks 6 days 13 hours), or D30 (2 months 3 weeks 6 days).
  • Multi-year values: D36 (1 year 2 months 3 weeks 6 days), D42, or D45.

Unit calibration

Formats that include days, weeks, months, or years honour the unit conversions configured on the work calendar. If your business day is 8 hours instead of 24, configure secInDay on the calendar so D13 (10d) reflects business days. See Work calendars → Advanced.

The time format chosen in a field setting applies everywhere that setting is rendered - the custom field and the Issue Navigator show the same format.


Truncation and totals

Every format has a smallest unit, and a value is truncated down to it. Nothing is ever rounded up. A stored value of 50 000 seconds is 13h 53m 20s exactly, and the same value reads:

  • 13h 53m in D12 and 13:53 in D11 - the 20 seconds are dropped
  • 833m in D4, 13h in D6 - whatever does not fill a whole minute, respectively a whole hour, is dropped
  • 13.8h in D9 - decimal hours (D7-D10) are truncated to 0.1 h
  • 13:53:20 in DEFAULT - the formats that carry seconds lose nothing: DEFAULT, D0, D1, D2, D44, D45 and D46
  • 13h 53m in AUTO - below an hour AUTO carries seconds and loses nothing (59m 27s); from an hour on it drops the seconds like D12

Day, week, month and year formats drop the remainder the same way, after the unit calibration above has converted the seconds into days.

Numeric values in JQL

The numeric schema properties are floored from the exact duration in the same way: HoursValue, MinutesValue and SecondsValue never round up, so 59m 27s answers [MinutesValue] = 59 and not = 60. TimeInHoursValue is the exception - it is rounded to the nearest 0.1 h.