Ceil

Returns the rounded-up value.

Variants

• Ceil(Duration duration, Duration significance)
• Ceil(Numeric number)
• Ceil(Numeric number, Numeric significance)
• Ceil(Time time, Duration significance)

Ceil(Duration duration, Duration significance)

Returns the smallest multiple of the significance which is greater than or equal to the duration.

Parameters

duration

The value you want to round.

significance

The multiple to which you want to round.

Returns

Duration

Remarks

Note that if the significance is negative, the result is closer to negative infinity than the duration is.

Examples

• Ceil(Hours(7), Hours(5)) returns 10 hrs
• Ceil(Hours(-7), Hours(5)) returns -5 hrs
• Ceil(Hours(7), Hours(-5)) returns 5 hrs
• Ceil(Hours(-7), Hours(-5)) returns -10 hrs

Ceil(Numeric number)

Returns the smallest integer greater than or equal to the number.

Parameters

number

The value you want to round.

Returns

Numeric

Examples

• Ceil(4.9) returns 5
• Ceil(-4.9) returns -4
• Ceil(-0.9) returns 0

Ceil(Numeric number, Numeric significance)

Returns the smallest multiple of significance which is greater than or equal to the number.

Parameters

number

The value you want to round.

significance

The multiple to which you want to round.

Returns

Numeric

Remarks

Note that if the significance is a negative number, the result is closer to negative infinity than the number is.

Examples

• Ceil(7, 5) returns 10
• Ceil(-7, 5) returns -5
• Ceil(7, -5) returns 5
• Ceil(-7, -5) returns -10

Ceil(Time time, Duration significance)

Returns the smallest multiple of the significance which is greater than or equal to the time.

Parameters

time

The value you want to round.

significance

The multiple to which you want to round.

Returns

Time

Examples

• Ceil(Time(21, 15), Hours(2)) returns 10:00 PM (or 22:00). 22:00 is the smallest multiple of 2, which is greater than 21:15