Known Variables
A1 = start date and time (6/16/15 6:00AM)
B1 = estimated hours to complete work order (15)
Work schedule is 6AM to 6PM, weekdays only
What formula can I use to calculate the end date/time, ignoring nonworking hours? It currently says that the estimated completion will be...