Excel formula that gives the Average amount of time if a corresponding cell falls between 2 times.

[CAM76]

Hi All,

New poster looking for any help would be greatly appreciated. What I'm lookingfor is a formula that will give me the average time it took to perform a taskbroken down by hour. Below is a look at the data I'm using.

Column A contains the time the task was started and B was the time it took tocomplete the task. I'd like to know the average amount of time it took tocomplete all tasks between the hours of 20:00-20:59:59. I've read a lot ofarticles trying to figure it out on my own and lots of trial and error, so anyhelp is appreciated. <o></o>

A B

15:40:22	0:08:01
20:34:52	0:08:09
17:22:20	0:08:16
10:21:56	0:11:49
11:10:41	0:07:38
18:21:52	0:14:17
15:02:56	0:13:10
20:08:38	0:11:56

<tbody>
</tbody>

 

[Robert Mika]

Hello and welcome:
Your table A2:B9:
D2: 20:00:00
E2:20:59:59
F2 confirm Control+Shift+Snter:
=AVERAGE(IF(A2:A9>=D2,IF((A2:A9+B2:B9)<=E2,B2:B9)))
Result: 10.02 minutes