Assuming real times in col B
In say, C1: =SUMIF(A:A,"C",B:B)
Just format C1 as percentage to taste
C1 will return the required percentage over 24 hours
(24 hours is equivalent to an underlying value of 1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Nanapat" wrote:
I need to arrive at the total percentage of time entered in all of Column B
(based on 24 hours) ONLY IF column A has the letter "C" in it. I'm having
trouble with my formula. Can someone help please? Example:

A B

C 2:30
L 3:40
W 1:00
C 1:00