I'm currently having a lot of trouble calculating estimates within working hours in excel.
Ill try to explain to the best of my ability what i am trying to accomplish.
Attached is my current documents for a reference (with added notes for clarity).
The Scheduling Test 1 document is just connected for an easy way for me to sort priorities which doesn't apply here. The main document is Estimate Test 1.
I'm looking for a formula that will add a specific amount of hours to a specific date and time ONLY during WORK HOURS (7:00 am - 3:30 pm with a 1 hour lunch break at 12 PM - 1 PM 7.5 hours total) and ONLY on WEEKDAYS (Monday - Friday).