I am exporting events from Airtable base into a web calendar via CSV. The web calendar requires that date and time be imported as separate fields.
To create a “date-only” field in Airtable, I simply duplicated the Airtable Date/Time field and turned off time. Done.
Now I need a way to create a separate “time-only” field in Airtable. Can someone recommend a formula that extracts the time from an Airtable Date/Time field? Converting it to text would be fine. For example, converting “4/14/2019 1:00pm” to “1:00pm”.
Thanks for your help