Caculating time between dates and counting if another criteria is met

[paddysheeran]

Hi All,

I need to amend a formula so I can

Calculate the hh:mm between 2 dates then count the occurance if another column's cell is true

Column L Holds the First Saved time
Column J Holds the Actual Start Time
Column K Holds the Medium (Email, Phone, Fax)
Time to Log (HH:MM) = L-J

My formula has to count all occurences where Time to Log is <= 04:00 and "E-Mail" appears in column K.

Any help would be greatly appreciated.

thanks,

Paddy.

[Bob Phillips]

Try

=SUMPRODUCT(--((L2:L200-J2:J200)<=--"04:00:00"),--(K2:K200="E-Mail"))