paddysheeran
02-09-2010, 10:01 AM
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.
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.