### Title

Failing to round time up

### Post

I'm using "round(aCalcFieldExpressingMM)" but the result is not rounding up. Does round not work with time values? The field I'm using expresses value only in minutes and even if the value is 14:55, when using round it still says "14" when I select "mm" in the inspector. I have also tried Ceiling to similar avail.

Using FM11, Snow Leopard, latest updates.

Thanks in advance.

I take shortcuts. The t is your time field. Set result as time.

UPDATE: If there are no seconds, my using < 30 still rounds the minutes down which is incorrect. I adjusted the calculation to:

Ceiling ( t / 60 ) * 60 - 60 * ( Seconds ( t ) and Seconds ( t ) < 30 )

The theory, round all the times up to full minute then deduct a minute if seconds are under 30. Portion in blue is boolean test which produces true if there is any number in Seconds ( t ).

"For some reason Round doesn't seem to play well with times."

Rounding is based upon Base 10 (decimal) instead of Sexagesimal.