Rounding up/down Time

[pjdodd]

Hello

I have a calculation field that adds together some time fields. (a+b+c=d)

At the moment the answer of d is always hours:mins:seconds

Im struggling to find a way to round up or down the result to the nearest minute, 10mins, or hour.

(Ive tried the Round, Ceiling and Truncate functions without effect).

Any ideas?

[RalphL]

Try Round ( TestTime / 600 ; 0 ) * 600

Time is number of seconds from midnight. 10 minutes = 600 seconds, so dividing by 600 gives the number of 10 minute parts. The Round gets rid of the fraction. Mutipling by 600 gets it back to time.

[pjdodd]

Thank you very much