Greetings,

I work at a call center and I'm trying to consolidate two sets of data - survey responses and phone call data.

Each time an employee takes a phone call, he/she must respond to a survey, what I'm trying to do is match the end call time (derived from phone call data table) with the time when the survey is finished (survey response data). And based on the closest date/time match and the name of the employee , I'd like to find the length of the phone call.

Attached is an excerpt of the table that I'm working with, I can easily just match up the end call times and names and manually enter them in, but I'm dealing with thousands of responses.

I greatly appreciate any insight!

Steven
data.xlsx