Hello to all Excel Gurus,
I would like to create a function to sum the total number of hours (Break/Lunch) based upon selections made in drop downs.
Please note, anyone of the shift hours can be chosen and it must correspond to the correct break and lunch calculation.
For 8 hrs you get .5break, .5 Lunch = 1hrs
For 10hrs you get .75break, .5 Lunch = 1.25hrs
Total time = 2.25Hrs
This is just for one day, I need to be able to do this *5days and for whatever combination of shift hours chosen.
I created Named ranges for my drop downs (On Schedule Tab) called
The Data is stored on Hours tab
Please help if possible.