Rounding functions

All three functions accept an optional significance. The default is 1. The return type matches the value being rounded.

`Ceil`

Rounds a value upward toward positive infinity.

Syntax: Ceil(value[, significance])
Requires: a Numeric, Duration, or Time value and an optional non-zero Numeric or Duration significance. Use a Duration significance when rounding a Duration or Time to an interval.
Returns: the same type as value.
Best for: minimum billable units and always-round-up quantities.

Ceil(12.1)
Ceil(Minutes(61), Minutes(15))

Rounds a value downward toward negative infinity.

Syntax: Floor(value[, significance])
Requires: a Numeric, Duration, or Time value and an optional non-zero Numeric or Duration significance. Use a Duration significance when rounding a Duration or Time to an interval.
Returns: the same type as value.
Best for: completed intervals and lower-bound bucketing.

Floor(12.9)
Floor([Elapsed], Minutes(5))

Rounds a value to the nearest significance; halfway values round away from zero.

Syntax: Round(value[, significance])
Requires: a Numeric, Duration, or Time value and an optional non-zero Numeric or Duration significance. Use a Duration significance when rounding a Duration or Time to an interval.
Returns: the same type as value.
Best for: display values, standard measurement steps, and nearest time intervals.

Round(12.5)
Round([Start Time], Minutes(15))

A significance of zero is invalid.

Last modified on September 7, 2026