login based leave calculation

hi team, how to calculating leave  I have employee logindetails  EMPID LOGIN DATE TIME  SHIFT EMPS001 1/4/2024 6.00 am 1 EMPS002 1/4/2024 6.00 am 1 EMPJ003 1/4/2024 6.00 am ...