Round to Nearest 15 mins

[DMGoldie]

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

[comment]

Try:

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

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

[DMGoldie]

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

[comment]

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

[DMGoldie]

Michael - That is perfect!

Thanks!

dmg

Edited September 5, 2006 by Guest