April 26, 200124 yr Newbies 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.
April 27, 200124 yr I assume you want to round to 70 for all values [=>61]. Try this Round((duration/increment)+4,-1)*increment. Regards.
Create an account or sign in to comment