Forum Discussion

sunadmin's avatar
sunadmin
Copper Contributor
Jan 18, 2019

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!

excel

8 Replies

    • sunadmin's avatar
      sunadmin
      Copper Contributor
      Jan 21, 2019

      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!

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jan 21, 2019

        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)

Resources