I want a formula in attendance sheet where i get half day calculation in today present days.
for ex-4 woff , 25 present.0 absent and 1 halfday so in my excel showing - total days present -30
but i need to get total days present -29.5

From India
Please find enclosed Attendance sheet in excel which you required Half Day Leave Half Day Absent.
From India, Bengaluru
Attached Files (Download Requires Membership)
File Type: xls Muster Roll May-18.xls (65.5 KB, 1462 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.