Thread: Time query
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Time query

Ber wrote:
Bob Sorry I worked out target cell but the formula only works if both ext nos
start a call at exactly the same time on the same date but what I need is if
2 ext nos are on the phone during the same time not necessarly starting or
ending at the same time, e.g someone could start at call at 09:10:00 and stay
on for 15 minutes ending at 09:25:00 and another person could start at
09:12:00 and stay on for 2 minutes ending at 09:14:neither started or ended a
call at the same time but used the phone during the same period of time, this
is what I want to get from this, as I am trying to find out on any date/time
what is the maximum usage of phones, in other words at what period of the day
on any date are most extension numbers used.It's driving me crazy.



There are three intersecting minutes (9:12, 9:13 and 9:14) for the two calls.
Please describe the results you are looking for.