Use COUNTIF to do this. Your formula should look like this, adjusting
the ranges to meet your data table:
=COUNTIF(B2:Z2,"=H")+COUNTIF(B2:Z2,"=H2")/2
Note that I used H2 for the half days and divided the count of those
entries by 2. Therefore, if your data range contains:
H, H, H2, H, H2 the result will be 4 (3 H+2 H2/2)
And use =COUNTIF(B2:Z2,"=T")")+COUNTIF(B2:Z2,"=T2")/2 to count the TOIL
days (what does TOIL stand for?) .
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=382566