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?

Oct 3, 2022 in Others 1,775 views

Try Something like =SUM(COUNTIF(\$A\$1:\$A\$8,"A"),COUNTIF(\$A\$1:\$A\$8,"HA")/2) - total count of A, and total count of HA divided by 2.
• 63,720 points

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

VBA, Query Vertica database and populate to excel

You can query Vertica directly from excel. I ...READ MORE

Excel formula to check date within this week and last week

Assuming the first date in A2 try this formula ...READ MORE

Creating an Instagram bot with reading an excel file and posing on Instagram, but some of words can not be read properly

The (account name) test1 100 euro #mountain ...READ MORE

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT ...READ MORE

Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE