Hi,

I am trying to round up time to the closest 15 mins.

Fields:

Service Start Time

Service Stop Time

Billable Time = (Service End Time - Service Start Time)/60

I want Billable time to round up to the closest 15 mins.

In other words I want billable time of 61 mins to equal 75 mins. I want 5 mins to equal 15 mins, etc...

Thanks!

dmg

Try:

Ceiling ( ( Service End Time - Service Start Time ) / 900 ) * 900

It's not clear to me why your calculation divides the result by 60.

Sorry I should have been clearer.

I want the billable time to display in .25 intervals of hours. So 62 mins of billable time should equal 1.25 billable hours, 35 mins of billable time should equal .75, and so on...

I changed the calculation to:

( Service End Time - Service Start Time )/3600

The calulation I gave above rounds time up to the next quarter-hour, and the result is TIME.

If you want the result in hours, make the result a NUMBER and use:

Ceiling ( ( Service End Time - Service Start Time ) / 900 ) * 0.25

Michael - That is perfect!

Thanks!

dmg

Edited September 5, 200619 yr by Guest