Adding Time to a date column to trigger an auto email notification.
I am creating a sheet that will help track when components need to be removed from our baking ovens based on its date in. Its a bit more complex then what I have done in the past so I need some help figuring out how I can do this.
So the Date In column is a Date type. I have it automated to fill out when a new line is added. I have a database sheet that has how long each part number needs to be baked before use. The bake times on the database sheet need to be added to the date in time to give me the Date Out time. I have attempted a few times but I am struggling writing out a function once dates get involved. Any help or advice on how I can get this to work would be much appreciated.
Help Article Resources
Check out the Formula Handbook template!