Home

How to add 1/2 days on a Attendance Tracker?

sunadmin
New Contributor

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!

3 Replies

Perhaps the easiest way is to add one more column here

image.png

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)