Using date and duration to generate standalone date, standalone time, and standalone time - duration?

[Heather_Dragule]

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!

[Justin_Barrett]

Here are the formulas. In all of these, replace “America/Los_Angeles” with the appropriate timezone for you. First, {Event Date}:

DATETIME_FORMAT(SET_TIMEZONE(Date, "America/Los_Angeles"), "dddd MMMM D, YYYY")

Next {Show Start Time}:

DATETIME_FORMAT(SET_TIMEZONE(Date, "America/Los_Angeles"), "h:mmA")

Finally {Doors Open Time}:

DATETIME_FORMAT(SET_TIMEZONE(DATEADD(Date, -1 * {Preshow Time}, "seconds"), "America/Los_Angeles"), "h:mmA")

[Heather_Dragule]

You’re the man, Justin! Thank you.