Fixed availability, but dynamic booking possible?

[DennisyuTSS1]

Hey everyone,

I am building a sort of meeting room booking system.

So the meeting room will have a fixed availability between 9am to 6pm
However, the bookings can have 5 variants:

• 15min
• 30min
• 45min
• 60min
• 90min

How can I allow people to book meetings based on the time they want, but block out the availability despite the duration differences? I'm happy to compromise and limit it to 2 options if necessary.

[Jack_Manuel]

You would need to make the end time dynamic. I believe the easiest way would be with a formula that adds the duration to the start time.

If I were you I'd remove the 'min' from your duration option names to make the end time formula cleaner. If you did this your end time formula would simply be,

DATEADD({Start Field}, {Duration Field}, 'minute')

If you need to keep the "min" in the option names, you could use a Switch() in your formula e.g.

SWITCH(
  {Duration Field},
  "15min", DATEADD({Start Field}, 15, 'minute'),
  "30min", DATEADD({Start Field}, 20, 'minute'),
  "45min", DATEADD({Start Field}, 45, 'minute'),
  "60min", DATEADD({Start Field}, 60, 'minute'),
  "90min", DATEADD({Start Field}, 90, 'minute')
)

This is not the most efficient way to write this but I find it to be the most readable and the easiest to update with new durations in the future if you need to.