Excel formula for half day count in attendance sheet?

index-sagar

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

Mallumudalagi

Please find enclosed Attendance sheet in excel which you required Half Day Leave Half Day Absent.

1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute