I want a formula in the attendance sheet where I get half-day calculation in today's present days. For example, if there are 4 days off, 25 present, 0 absent, and 1 half-day, my Excel is showing a total of 30 days present. However, I need the total days present to be 29.5.
From India
Acknowledge(0)
Amend(0)
1From India
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
EXCEL FORMULA.xls