Logic Required

[navi1688]

Hello

Looking to create a report to bring the output in the format available in "sheet 2"

1. If the swiped hrs is greater than 0, then it should be considered work from office. otherwise, work from home.
2. If C column says "holiday or leave" with total hrs (swiped+WFH hrs) is 0, then it should be considered as leave.
3. Few members apply for holiday but work on these days, it could be either work from office or home. Logic required similar to point 1.

Thank you in advance.

 

[mohamed ilyas]

Hi Navi,

is this ok for you?

thanks
ilyas

 

[navi1688]

Hi Navi,

is this ok for you?

thanks
ilyas

Thank you ilyas for your time and help. Will check and apply it on my main. Will revert in case of further help required.