Counting half days holiday and sickness in excel
 

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

Counting half days holiday and sickness in excel
 

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

Counting half days holiday and sickness in 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

Counting half days holiday and sickness in 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

Counting half days holiday and sickness in excel
 

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