If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Averaging times that are not in a range
I am trying to get an average response time for numbers that are not listed
in a range. They are formated as a custom format like this: h:mm:ss. I have been able to get a range to work, but not durations that have other cells between them. Below is a picture of my table. The three center times, Dispatch Time to On Scene, are the times I would like to average. Can you please help me with the correct calculation? Thanks! Tk-1 - Sta 1 - 96 Acoma Dispatch Time to Enroute 0:01:29 Dispatch Time to On Scene 0:06:00 Total Time-Dispatch to Available 0:29:15 E-2 - Sta 2 - 2065 Kiowa Dispatch Time to Enroute 0:01:26 Dispatch Time to On Scene 0:06:14 Total Time-Dispatch to Available 0:33:30 E-3 - Sta 3 - 3620 Buena Vista Dispatch Time to Enroute 0:01:17 Dispatch Time to On Scene 0:05:47 Total Time-Dispatch to Available 0:39:24 |
#2
|
|||
|
|||
Averaging times that are not in a range
This is an array formula that should be committed by pressing Ctrl-Shift-Enter
Assuming your data is in column A, starting in row 2 =AVERAGE(IF(A2:A14="Dispatch Time to On Scene",B2:B14)) "Nancy D" wrote: I am trying to get an average response time for numbers that are not listed in a range. They are formated as a custom format like this: h:mm:ss. I have been able to get a range to work, but not durations that have other cells between them. Below is a picture of my table. The three center times, Dispatch Time to On Scene, are the times I would like to average. Can you please help me with the correct calculation? Thanks! Tk-1 - Sta 1 - 96 Acoma Dispatch Time to Enroute 0:01:29 Dispatch Time to On Scene 0:06:00 Total Time-Dispatch to Available 0:29:15 E-2 - Sta 2 - 2065 Kiowa Dispatch Time to Enroute 0:01:26 Dispatch Time to On Scene 0:06:14 Total Time-Dispatch to Available 0:33:30 E-3 - Sta 3 - 3620 Buena Vista Dispatch Time to Enroute 0:01:17 Dispatch Time to On Scene 0:05:47 Total Time-Dispatch to Available 0:39:24 |
#4
|
|||
|
|||
Averaging times that are not in a range
I want to thank all three of you for responding to my question, Duke Carey,
Bernard Liengme and P45cal. I tried all of your solutions, and they all did the trick! I so appreciate your time and expertise! -- Nancy D "Nancy D" wrote: I am trying to get an average response time for numbers that are not listed in a range. They are formated as a custom format like this: h:mm:ss. I have been able to get a range to work, but not durations that have other cells between them. Below is a picture of my table. The three center times, Dispatch Time to On Scene, are the times I would like to average. Can you please help me with the correct calculation? Thanks! Tk-1 - Sta 1 - 96 Acoma Dispatch Time to Enroute 0:01:29 Dispatch Time to On Scene 0:06:00 Total Time-Dispatch to Available 0:29:15 E-2 - Sta 2 - 2065 Kiowa Dispatch Time to Enroute 0:01:26 Dispatch Time to On Scene 0:06:14 Total Time-Dispatch to Available 0:33:30 E-3 - Sta 3 - 3620 Buena Vista Dispatch Time to Enroute 0:01:17 Dispatch Time to On Scene 0:05:47 Total Time-Dispatch to Available 0:39:24 |
Thread Tools | |
Display Modes | |
|
|