Prevent overlap through data validation

[milt2010]

Hi!
In a worksheet with a table with date, start time and end time that I will share online (on Onedrive) I would like to avoid overlapping when entering the new dates, start and end times.

The scenario is exactly this: on the same day, it must not be possible to insert two times that overlap in some way (even by just 5 min.)
Very important: is it possible to make this work online through Data Validation?
I attach an Onedrive link, Prevent Overlap with Data Validation to open the file locally ("File"> "Info"> "Open in Desktop App") and for any online tests.

Thanks in advance.

 

[fadee2]

hi,
What are you trying to achieve actually? Didnt get your question exactly.

If what I understood from your question is "creating a single entry for start and end time for each day", then you can always use conditional formatting to highlight the dates if they appear twice, and then manually change the data as required.

OR

You can use VBA to input the data through a userform, while checking each entry for a duplicate date.

A question though, why do you need data validation to complete this task?

 

[milt2010]

hi,
What are you trying to achieve actually? Didnt get your question exactly.

If what I understood from your question is "creating a single entry for start and end time for each day", then you can always use conditional formatting to highlight the dates if they appear twice, and then manually change the data as required.

OR

You can use VBA to input the data through a userform, while checking each entry for a duplicate date.

A question though, why do you need data validation to complete this task?

Hello and thank you for answer.
This is a meeting scheduling file. What I need, as this file will be used online together with other ADMINS, is that hours that have already been programmed cannot be entered in the same day and therefore create an overlapping of even just 5 minutes. Unfortunately I cannot use the VBA. I had originally integrated a VBA function to achieve this but the VBA only works locally online doesn't work. Also, simple conditional formatting is not good because it would not prevent a user from entering incorrect data as does data validation. For this I would like to use the data validation for its prerogative to make a warning / error message appear and block the insertion until the correct data is entered. I hope it is more understandable now ...

 

[fadee2]

Meaning...
each date can hold more then 1 meetings, but the hours should always be different?
or
each date should hold only 1 meeting.

 

[milt2010]

Meaning...
each date can hold more then 1 meetings, but the hours should always be different?
or
each date should hold only 1 meeting.

Yes, the first: each date can hold more than one meeting but the hours should always be different.