Get only the hour of last modified time

Topic Labels: Formulas
767 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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
6 - Interface Innovator
6 - Interface Innovator

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: