Counting half days holiday and sickness in excel

[Wayne]

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

 

[Bob Phillips]

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}))

 

[Ronteebee]

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

 

[Ronteebee]

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

 

[Ronteebee]

Hi Wayne. Read your posting re: 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.