Try this:

=SUMIF(A1:A4,"C",B1:B4)*24/24

Format as Percentage

--
Biff
Microsoft Excel MVP


"Nanapat" wrote in message
...
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