Hi,

I'm trying to round a calculation field (time).

The simple calculation is RestTime/RestTimeTotal*PayableRestTime (all times). For example, with the following values: 0:07/27:00*27:00 the calculated value is 0:06:59,999999 (hhmmss)

If I set the time format to hhmm, the value is 0:06 instead of 0:07.

Is there a simple way to correctly round up the calculated time value, I seem to have a mental block with this one...?

Thanks in advance,

JariV

field

Try:

Round ( RestTime / RestTimeTotal * PayableRestTime ; 0 )

This rounds to the NEAREST second - to round up or down, use Ceiling() or Floor().

BTW, this part isn't correct:

with the following values: 0:07/27:00*27:00 the calculated value is 0:06:59,999999

If the values were EXACTLY that, the result would be 0:07:00.

Thanks a lot, worked perfectly.

If the values were EXACTLY that, the result would be 0:07:00.

I was also wondering this myself. I checked these again, the values were 0:07:00/27:00:00*27:00:00 (at least when formatted as time). However, one of these values is calculated by an external plugin, maybe that calculated underlying value is not exactly even seconds?

JariV

It should be easy to find out by clicking into a field (assuming you have a field for it) or by Data Viewer.