Hi I have setup the formula to count H for holiday and S for sickness within
excel but if i have half a day i can not do it can someone help please?

Thanks

Wane

Use H for a full day, h for a half day, and then use

=SUMPRODUCT(EXACT(C2:M2,{"H";"h"})*{1;0.5})

if the data goes across columns. If it goes down rows, use

=SUMPRODUCT(EXACT(B2:B20,{"H","h"})*({1,0.5}))

--
__________________________________
HTH

Bob

"Wayne" wrote in message
...
Hi I have setup the formula to count H for holiday and S for sickness
within
excel but if i have half a day i can not do it can someone help please?

Thanks

Wane

"Wayne" wrote:

Hi I have setup the formula to count H for holiday and S for sickness within
excel but if i have half a day i can not do it can someone help please?

Thanks

Wane

"Wayne" wrote:

Hi I have setup the formula to count H for holiday and S for sickness within
excel but if i have half a day i can not do it can someone help please?

Thanks

Wane

Hi Wayne. Read your posting holiday formula. Am brand new to Excel.
Want to set up similar format using HH as full day holiday H as half day
as well as S for sickness, UP for unpaid etc.... Can you help with the
intitial setting up of the formulas with letters reflecting in sums of day
taken. Hope this makes sense...as I said.... am very new and inexperienced
with Excel.
"Wayne" wrote:

Hi I have setup the formula to count H for holiday and S for sickness within
excel but if i have half a day i can not do it can someone help please?

Thanks

Wane