Get only the hour of last modified time

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

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!

1 Like

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