Time format rounding

[JariV]

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

[comment]

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.

[JariV]

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

[comment]

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