Sum Column Differences between date range

[Kellogg]

Dear Great Minds of Excel,


I have the following data (Except column D)

Column A     Column B        Column C       Column D     Column E     Column F      Column G
Date 1         Start Time 1    End Time 2     Difference    Start Date    End Date       Avg Time to Complete
01/01/14     08:00              08:30             00:30          2/1/14         2/28/14        00:25
01/0714       09:00             09:10              00:10
02/04/14     10:00              10:18              00:18
02/22/14     11:00              11:02              00:02
02/25/14     12:00              12:30              00:30


I want a vba code that will calculate the time difference between Column B and Column C (shown in column D) then calculate the average time to complete tasks over a date range designated in Cells E1 and F1.

Cell E1 = 02/01/14 This is the start of the date range.
Cell F1 = 02/28/14 This is the end of the date range.
Cell G1 = Average time to complete task within date range.

I do not need to have the differences listed in column D.  This is for clarification. The answer should be 00:18 + 00:02 + 00:30 / 3 = 00:25. 

Something using:
Application.Worksheetfunction.sumifs(DateRange1, ......

Any help is always appreciated.  Thanks

 

[Kellogg]

Joeu2004,

A second solution that works! Thanks. I use the Sumifs and Countifs and this is a great lesson. Another early Christmas present.