Hello Forum,
I am intermediate Excel User and need help with below
My employees log their task hours through out the day and week (even on weekends and holidays)
My "Y" column contains start time of their task and "Z" column contains end time of their task.
Now my office working hours are Weekdays 0900-1800, excluding holidays.
Now using the start time and end time they logged, I need to find, how many hours they worked outside 0900-1800 (that is working hours)
If it is a weekend or holiday then that whole task time is outside working hours.
Scenario 1: If a employee starts it's task at 1600 on a weekday and ends the task at 2100. He worked total of 5 hours but only 3 hours are outside working hours. I need these 3 hour calculation
Scenario 2: If a employee starts it's task at 1600 on weekend/holiday and ends the task at 2100. He worked total of 5 hours and all these should be considered outside working hours.
Please help with your expertise
Thanks in advance!
Bookmarks