You need to get elapsed time in minutes (I'm assuming that's as fine as you want to cut it) using
DateDiff(), then parse it out, something like this:
- TotalMinutesElapsed = DateDiff("n",[Start Date], [Shut Off Date])
-
HoursElapsed = TotalMinutesElapsed\60
-
MinutesElapsed = TotalMinutesElapsed mod 60
-
Be sure to notice the
back slash in the
HoursElapsed formula. This causes Access to return only the interger (hours) portion of the division.
Welcome to
Bytes!
Linq
;0)>