Two tables... each tracking different aspects of time spent on a "case" (talk and documentation). I want to capture the total time each person spends on a case on a given day but EXCLUDE overlapping times.
For example (see attached), BOB talked from 7-7:30 and documented from 7:05-7:40. Bob spent 30 min taking and 35 min documenting, but was doing one or the other from 7-7:40 - 40 minutes. Therefore, I would like to capture the 40 minutes that Bob was EITHER talking or documenting. Again per example, total Talk Time was 95 minutes and Total Documentation Time was 195 minutes, but total time where people were doing one or the other was 215 Minutes.
Need to use SQL to accomplish this - no VB please.