T
Twiggy
Hi
Please help.
I have two sheets as follows:
Sheet 1:
Date / Time / Number Dailled / Duration
/Cost
22/1/10 10:00 01234123456 00:01:57 0.789
Sheet 2:
Date / Time / Number Dailled / Duration
/Extension
22/1/10 10:02 01234123456 00:01:56 1501
I am trying to put the cost of the phone call against the relevant extension
on sheet 2 that has dialled the number dialled. Obviously I can match the
number dialled in both cases, and the date, but there may be calls made to
that same number by that same extension on that same date but at a different
time, so I need to incorporate the time into the formula, to say if the date
matches and the number dialled matches, and the time difference between the
two is (say) less than 3 minutes (as that is about the difference I am
looking at) then give me the cost of that call in the column next to the
extension number on Sheet 2.
Sorry for the waffle but can anybody help.
Thank you
Please help.
I have two sheets as follows:
Sheet 1:
Date / Time / Number Dailled / Duration
/Cost
22/1/10 10:00 01234123456 00:01:57 0.789
Sheet 2:
Date / Time / Number Dailled / Duration
/Extension
22/1/10 10:02 01234123456 00:01:56 1501
I am trying to put the cost of the phone call against the relevant extension
on sheet 2 that has dialled the number dialled. Obviously I can match the
number dialled in both cases, and the date, but there may be calls made to
that same number by that same extension on that same date but at a different
time, so I need to incorporate the time into the formula, to say if the date
matches and the number dialled matches, and the time difference between the
two is (say) less than 3 minutes (as that is about the difference I am
looking at) then give me the cost of that call in the column next to the
extension number on Sheet 2.
Sorry for the waffle but can anybody help.
Thank you