Hi, i have an attendance template and i want to compute for the number of regular hours worked and number of holiday hours worked especially when a shift starts from a regular day then ends on a holiday, and vice versa.. i have a cell that determines if a shift date, log in date and log out date falls on a holiday or not.. work hours is 8 hours plus 1 hour lunch.. im stuck on what to do next.. any assistance is highly appreciated.. ill attach a sample for reference..
Bookmarks