Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to Get 12 Hour Clock Time Value

246 1
Showing results for 
Search instead for 
Did you mean: 

I am trying to get a formula to display the time of a date field, in 12 hour format.

Example: I have a date field set to 03/18/2022 6:00pm. I have a formula that is pulling just the time of that field : TIMESTR({Start}). This produces 18:00:00. But I’d love to get this in a simple: 6:00pm, or even 6:00.

I tried this wild formula, but that produces an error: DATETIME_FORMAT(TIMESTR({Start}),"hh:mm"). I’ve also looked around at some of the other solutions, but most require 2-3+ fields to get the number. Is there a simpler, “all-in-one-step” formula to achieve this?

1 Reply 1

…and I answered my own question. Apparently, you can do the date/time format function to extract just time: DATETIME_FORMAT({Start}, "h:mm" ), produces 6:00