Formula Needed

[Guest]

I am looking for a formula that will read (1/2 H) this for a register that i
am building and i need to read if there is a half days holiday as i have one
that reads if there is a holiday witch is =countif(k8:k17,"H") i need this to
link in with that formula so it count up half days holidays

would be greatful if there is anyone that could help...

Cheers

 

[Guest]

Hi

You could try:
=countif(k8:k17,"H") + (COUNTIF(K8:K17,"1/2 H")/2)

Hope this helps.
Andy.

 

[Bob Phillips]

An alternative way is to use H for a full day, h for half days, and use

=SUMPRODUCT(--(ISNUMBER(FIND(LOWER("H"),A1:A10)))/2+
ISNUMBER(FIND(UPPER("H"),A1:A10)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

A better formula is

=SUMPRODUCT(EXACT(A1:A10,{"H","h"})*{1,0.5})

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)