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