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