Thanks very much to T. Valko and Max for taking the time to help me out. One
more question, please. I want to calculate the percentage of the "C"s in
column A, compared to ALL of column A. Can you help me once more?

"T. Valko" wrote:

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