Time Calculations in Increments

[Michelle]

I need help in calculating elapsed time in increments of
15 minutes. If more than 18 minutes, it should roll over
to the next increment. Right now, calc is (timeout -
timein) = hh:mm format. Thanks!

 

[Allen Browne]

Type this expression into the Field row of a query:
Minutes: 15 * CLng(DateDiff("n", [timein], [timeout])/15)

The expression returns the number of minutes between the timein and timeout
fields, rounded to the nearest quarter hour.