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

Copper 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!

8 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)

@Sergei Baklan  Thank you very much.  your solution worked beautifully.

@sunadmin , you are welcome, glad to help

How can I do something like this but only for a month
Monthly attendance sheet with add half day and duple day , and add off day (o) to present day (p)
Please help me to do it

@Mina_Mounir 

I'm not sure why solution as above in this thread doesn't work.