Rounding durations

[dafnis14]

Hi,

I have an expression for rounding durations, with a variable for the rounding step:

Interval(Round(ParkingDuration,(1/$(vDurationFrac))),'hh:mm'))

vDurationFrac can be 24,48,96  (for 15,30,60 minutes).

When selecting fractions of 30 minutes, it's not clear how the rounding is done.

For example, duration range from 1:45 to 2:14 hours are rounded to 2:00 hours.

There are values 1:44 or 2:15 which are not taken into account.

Can someone clarify please?

Thanks!

[dafnis14]

I guess I figured it ..

according to Round Help:

"... If x is exactly in the middle of an interval, it is rounded upwards..."

[vinieme12]

please post some sample data with expected output