Can concatenate formula show just times, WITHOUT the date?

[Jessica_Pena]

I’m trying to establish a schedule of events for a multi-day event and it would be optimal to have the primary field with a concatenate formula read:

CONCATENATE({Description (from Performer)}, " by ",{Performer}, " from ", {Start Time}, " to ", {End Time})

However, for Start and End times, I would love if ONLY the time (sans date) would show, because currently I have this mess showing:

Classical String Duet by XYZ Strings Band from 2022-04-14T02:00:00.000Z to 2022-04-14T03:30:00.000Z

TIA, Community!

[Vivid-Squid · Accepted solution]

Hi @Jessica_Pena ,
There is a TimeStr() option you can use in your formula. There are also other formats you can display the time as with DATETIME_FORMAT() : https://support.airtable.com/hc/en-us/articles/216141218

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...

To add the DATETIME_FORMAT to your formula:
CONCATENATE({Description (from Performer)}, " by ",{Performer}, " from ", DATETIME_FORMAT({Start Time},‘LT’), " to ", DATETIME_FORMAT({End Time},‘LT’))

[Jessica_Pena]

Thank you very much!