Skip to main content

Format Strings

Format strings control how numbers, dates, and durations are displayed in tables, CID cells, and exports. They follow a familiar .NET/printf-flavoured shape that should look right at home to anyone coming from HH Data Management.

Numbers

FormatExample inputOutput
042.743
0.042.742.7
0.0042.742.70
0.00042.742.700
#,##01234512,345
0%0.34535%
0.0%0.34534.5%
0.00e+00123451.23e+04

Durations (lap-time format)

FormatExample input (ms)Output
m:ss.000923451:32.345
m:ss.fff923451:32.345
h:mm:ss54000001:30:00
s.fff12341.234

See Lap-time Format for the dedicated lap-time discussion.

Dates and times

FormatExampleOutput
yyyy-MM-dd2026-03-21T14:30:00Z2026-03-21
HH:mm:ss2026-03-21T14:30:00Z14:30:00
dd MMM yyyy2026-03-21T14:30:00Z21 Mar 2026
ddd HH:mm2026-03-21T14:30:00ZSat 14:30

Date / time formatting uses the host's intl (Dart) or Intl.DateTimeFormat (TypeScript). Timezone defaults to the event's timezone if one is set on the Event row, otherwise browser local.

Where format strings appear

  • Definitions Editor — every numeric parameter has an optional format string
  • Custom Views Editor — CID cells and table columns both accept a format string
  • Custom Columns Editor — column-level format string

What's coming

  • Unit suffix insertion — automatically append the parameter's unit (e.g. 0.0 °C) — today you write it into the format string manually
  • Conditional formatting (e.g. red for outliers) — currently handled by rowAccent expressions only
  • Right-to-left languages in dates