Ok. Is this even possible. I work for an answering service and trying to determine the time between a call being placed and a call returned. Say you have the following values:
callNo time returncall time returned
A1 12:00
A2 1:00
A3 1:34
A4 2:15
3:00 A1 3:00
3:30 A2 2:30
4:00 A3 2:26
4:30 A4 2:15
Say for e.g call A1 was placed at 12:00 and returned at 3:00, so it was 3 hours between the time call placed to returned. And so in, Is there any easy way to do this? I have tried a few fornulas, but nothing has given me what I need.
Bookmarks