Multiple Condition

[sgaryali]

Hi

I want to calculate Total Hours

On conditions -

1) If date in Sample Start time & End time is matching with holiday file then I need to subtract (24 - Punch In) which will give 4 hrs

2) If date in holiday file is of previous day like we have 1/31/2022 and date in sample Start time & End time is of next day like we have 2/1/2022 then we need to subtract (24- Punch Out).

I know we have to use Join tool to take same date for first scenario but I am not sure what can we do second scenario?

Can anyone help please

[sgaryali]

Thank you for the help @atcodedog05 

This is not what I am looking at we don't need to calculate Total Hours for dates other than matching Holiday file.

Like - 2022-01-02,2022-01-05, 2022-01-06..............

Dates which are common in both files those are to be taken into consideration then we have to check whether the date is falling on last of month if yes then (punch out - 24) otherwise (24- punch in).

Maybe I am not able to explain it anyways thank you so much for your help I will try some other way  :) .