Can concatenate formula show just times, WITHOUT the date?

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!

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

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’))

image

4 Likes

Thank you very much!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.