Time Calculations in Increments

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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!
 
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.
 
Back
Top