Try this:

=IF(B10="*",AF8+10.64,AF8)-(SUM(COUNTIF(B1:K1,{"*SE*","*SF*"}))*24)

--
Biff
Microsoft Excel MVP


"ken" wrote in message
...
I have created a time card program for work. we work 24 hour periods. if
the
member calls in sick for the entire shift I have figured out. what i can
not
figure out is how to get the formula to recognize how many hours of sick
time
are being used for the day if not equal to 24 hours. example: if the block
holds "SE/11" then the member was sick for 13 hours and worked 11 hours.
the
block my even read "8/SE", where the individual worked 8 hours and was
sick
for 16 hours. I am not sure how to get that formula to recognize the SE in
this instance?

THE FORMULA IS:

=IF(B10="*",AF8+10.64,AF8)-(COUNTIF(C11:AD11,"SE")*24+COUNTIF(C11:AD11,"SF")* 24)

The (B10="*",AF8+10.64,AF8) part of the formula is not relevant to
calculation of sick time other than bringing down the sick time balance
from
the previous period. If the entire worksheet is needed i can provide it
and
the formula. thanks again for any help possible