Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Get only the hour of last modified time

Topic Labels: Formulas
1229 2
cancel
Showing results for 
Search instead for 
Did you mean: 
clement_desrues
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
Chris-T
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!

clement_desrues
5 - Automation Enthusiast
5 - Automation Enthusiast

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