Counting half days holiday and sickness in excel

  • Thread starter Thread starter Wayne
  • Start date Start date
W

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
 
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}))
 
Wayne said:
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
Click to expand...
 
Wayne said:
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
Click to expand...
 
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.
 
Back
Top