Forum Discussion
How to add 1/2 days on a Attendance Tracker?
Hello!
I am using Microsoft attendance tracker-
https://templates.office.com/en-us/Employee-attendance-tracker-TM02809209
How do I track 1/2 days in both vacation and sick?
Thank you very much!
8 Replies
Perhaps the easiest way is to add one more column here
and the formula in Days column change on
=NETWORKDAYS([@[Start Date]],[@[End Date]],lstHolidays)+[@Adjustment]
Correct format of these two columns after that.
Please see attached
Hello Sergei,
Thank you for your reply.
However, I'm using a different tracker than the one you've suggested a solution for.
The template we're using is:
https://templates.office.com/en-us/Employee-attendance-tracker-TM02809209
Can you please suggest a solution for 1/2 days for this tracker?
Thank you!
Hi,
Instead of "s", "v", etc. you may type "0.5s", "0.8v", etc. and instead of COUNTIF use formula as
=SUMPRODUCT(VALUE("0"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($F6:$CQ6,"p",""),"v",""),"s",""))*(RIGHT($F6:$CQ6,1)="S"))+SUMPRODUCT(--($F6:$CQ6="S"))this one is for sick leaves, another two are similar.
Plus in conditional formatting rules change formulas like
=F6="S" on =RIGHT(F6,1)="S"
Please check in attached file (it's done for 1st quarter only)
