I'm trying to write a column validation for a SharePoint calendar to ensure all bookings are after 8.30am in the morning and before 5pm at night.
I've tried the following:
=AND(TIME(8,3,0) < [StartTime], TIME(17,0,0) > [StartTime])
But it doesn't work.
Can anyone advise how to successfully compare a column against a specific time?
Thank you!