Sample test skip.xlsxSample test skip.xlsx
I manage a team that makes deliveries within a campus, based on a delivery time for each route(A2-17), special package (C2-17) and Regular Parcel (D2-17). I want to be able to drag a formula (if possible) based off a variable start time (H2) then each time is added based on if there is a "special" and/or "Reg" delivery (see row G & H) in addition to travel time (F2). I would also like to add lunch (F2) if the route time goes beyond noon.

I have created rudimentary formulas but every time there is a blanket cell I have to manually corrected. I also have to manually have to add the lunch if I am creeping on noon or if the route takes the person over.

Any and all help will be appreciated>

Jaycee66