I’m looking to generate a the following fields:
Date (ex: Wednesday, January 1, 2020)
Doors Open Time (ex: 7:00PM)
Show Start Time (ex: 7:30PM)
From a DATE field that represents the show date and show start time (inputted together per Airtable), and a DURATION field that represents how many minutes BEFORE the start time the doors will open.
Anyone know how to write the formulas for this? Much appreciated!