How should I create three 30 min time slots from an existing date time field

Topic Labels: Formulas
613 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi team,

I am looking for a solution to create the time slots from the existing date & time field. One of our clients wants a solution to this. They have created the appointments in the Google calendar which is synced with the Airtable. Here the synced record has only a single date and time and they want us to book 3 appointments in this slot by automating the bookings with 30 min intervals of actual time. For example, if an appointment is set for May 22, 2023 2 PM then the 3 bookings will be booked like  May 22, 2023 2 PM, May 22, 2023 2:30 PM  May 22, 2023 3 PM. Does someone have any idea how should we create a formula to create this kind of slot in the Airtable field?

1 Reply 1

use formula DATEADD({Field},30,'minutes') , same with 60 and 90