Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Get only the hour of last modified time

Topic Labels: Formulas
247 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey, do you know how can i get in a field, only the hour format Hour/minutes like 09:34, without the date ?? thank you

2 Replies 2

Hi Clement. Try this…

DATETIME_FORMAT(SET_TIMEZONE({Last Modified}, ‘America/New_York’), ‘h:mm a’)

Use your own timezone (it may be ‘Europe/Paris’) in the SET_TIMEZONE function. You can find the list here Supported timezones for SET_TIMEZONE – Airtable Support

Good luck!

Thank !! This is exactly what I was looking for ! I just find the format of the Formula, really amazing :slightly_smiling_face: