Hi jcrawf02,
You have a very valuable suggestion to modify the solution. The solution should sum the duration from your downtime table between the two points of time and subtract it from the total time. Check my solutions. It counts for the lunch break timings also.
Sincerely,
Maz
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]