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 m...
excel
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)

Mina_Mounir's avatar
Mina_Mounir
Copper Contributor
Sep 26, 2021
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
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 26, 2021

    Mina_Mounir 

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