I have three time fields in a table to track event details for our clients- Start Time; Arrival Time and End Time
I would like to have Arrival Time and End Time autofill from Start Time based on a standard 5 hour end after Start time and a 1 hour arrival before Start Time. However, since there is an option to add additional time to Arrival or End by the client, I would like those values to shift by one hour based on another set of fields for Early Arrival or Additional Hour. I believe I need to create a script in the field for each autofill time but am having difficulty getting the time to advance by five hours or select one hour earlier. For the optional hour options, would I need to use If, Then to reset the time options?