Rounding Up

[eddieleavens]

I have a brain cramp. How do I force "round" to round up? i.e. if an event is timed at 62 seconds, and I need it invoiced in increments of 10 seconds, the round command on 62 seconds gives me a result of 60 <<round(duration / increment)*increment>>. How do I get around this? I want the result to be 70 seconds. Please help !

Thanks, Ed.

[miramaya]

I assume you want to round to 70 for all values [=>61].

Try this

Round((duration/increment)+4,-1)*increment.

Regards.