Help

Can concatenate formula show just times, WITHOUT the date?

Topic Labels: Formulas
Solved
Jump to Solution
629 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jessica_Pena
7 - App Architect
7 - App Architect

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!

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

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

See Solution in Thread

2 Replies 2
Vivid-Squid
11 - Venus
11 - Venus

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

Thank you very much!