Hmm... this may work:

=SUMPRODUCT(--(RIGHT(A1:A100,1)="A"),--(LEFT(A1:A100,FIND(":",A1:A100)-1)))+INT(SUMPRODUCT(--(RIGHT(A1:A100,1)="A"),--(MID(A1:A100,FIND(":",A1:A100)+1,2)))/60)&":"&MOD(SUMPRODUCT(--(RIGHT(A1:A100,1)="A"),--MID(A1:A100,FIND(":",A1:A100)+1,2)),60)

This will return an error if you have any blank cells or data that does not
fit your specified format of H:MM. If you do have blanks in your range, you
could fill them with the text value 0:00.

HTH
Elkar


"LMarks" wrote:

We use 3 letter codes (A, S, P) for leave taken by an employee. The number
of hours is entered as H:MM, then the letter leave code (e.g., 1.45A, 2.30S,
4:15P). I need a formula to add the total number of hours in each row for
the three letter codes. I have spent hours searching for formulas online and
am not sure which functions to use (SUMIF, SUM, etc.)

I also need a formula that would convert the a total number of leave hours
e.g., 147.70=148.10, 1233.89=1234.29, 602.97=603.37. Any help would be
greatly appreciated.