I'm making leave trackers for several of my staff. This tracker keeps tabs on sick days, partial days, parental leaves, annual leaves, and work-from-home days.
Each of the 12 tabs represents a month of the calendar and highlights the days and dates. At the bottom of each tab is a total column that counts the number of annual leaves and half-days only (as the others are not deducted from their annual allowance).
Annual Leaves = A
Half Days = HA
Is there a formula I can use, to sum up the annual leaves and half days for each employee where half days is equal to 0.5 of a day rather than a day? So if one has 2 days of annual leave in January and 3 half-day leaves in January; what formula can I use to show 3.5?