
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2021 06:04 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 11, 2021 08:31 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 12, 2021 03:38 AM
Thank !! This is exactly what I was looking for ! I just find the format of the Formula, really amazing :slightly_smiling_face:
