Skip to main content

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!

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 🙂

Reply


Terms & Conditions