Experts, I am working within my Access DB and using VB to sum up the Cycle Times of a days worth of machine processes. My DB records the finish time (long date) each time my CNC completes a job through the day, which I can use as the cycle time (ie. the difference between finish times of two adjacent job records). However within my VB calculation I need to check if the cycle time included the employee's break or lunch and remove that duration from the cycle time.
For example, I have a two finish times as "12/1/2017 9:47:03 AM" and "12/1/2017 10:33:29 AM". This calculates for 46.43 minutes, however it included a break time that occured from 10:00 am until 10:20 am which needs to be detected and removed from this particular cycle time. Is there an easy way to check for the break time duration between a the cycle time?