Jan 18 2019 03:53 PM
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!
Jan 19 2019 07:53 AM
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
Jan 20 2019 06:02 PM
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!
Jan 21 2019 09:23 AM
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)
Jan 02 2020 05:19 PM
@Sergei Baklan Thank you very much. your solution worked beautifully.
Jan 02 2020 05:39 PM
@sunadmin , you are welcome, glad to help
Sep 26 2021 06:41 AM
Sep 26 2021 06:45 AM
Sep 26 2021 11:37 AM
I'm not sure why solution as above in this thread doesn't work.