Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate events that happened at the same time?
Dear all,
I am trying to find a way of calculating how many people were taking a call at the same time as one and other. I have exported the following data into Excel and am trying to find a formula which will achieve this: Column1: Start Time Column2: # of Calls made at Start Time Column 3: Call Duration Column 4: Finish Time 08:07 1 47.00 8:07 08:11 1 135.00 8:14 08:12 1 92.00 8:13 08:18 1 296.00 8:23 08:24 1 192.00 8:27 08:29 1 83.00 8:31 08:35 1 124.00 8:37 08:36 1 93.00 8:38 08:37 1 170.00 8:40 I would like to also create a chart to display this information? Thankyou in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
Calculate % of events based on days worked | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
Finding concurrent events from a list with a start and an end time | Excel Discussion (Misc queries) | |||
I need to measure hours between two events(time/date) to give me . | Excel Worksheet Functions |