Hi,
I have a spreadsheet which includes columns for name, date and shift and I want to make sure that shifts do not overlap. At the moment we have to sift through shifts and use data sort etc and it takes ages.
I'm sure it's quite easy to do this for identical bookings (identical in name, date and shift columns), probably using a countif formula in data validation, but what if the shift time is just overlapping, and not identical (for example a 0900-1500 shift and a 1200-1700 shift by Joe Bloggs on the 23rd of March).
If this is possible then is it possible to do the check across workbooks (sometimes staff work in different departments, which have their own spreadsheets).
Furthermore is it possible to do this without VBA which hurts my poor brain.
Thank you
Dave
I have a spreadsheet which includes columns for name, date and shift and I want to make sure that shifts do not overlap. At the moment we have to sift through shifts and use data sort etc and it takes ages.
I'm sure it's quite easy to do this for identical bookings (identical in name, date and shift columns), probably using a countif formula in data validation, but what if the shift time is just overlapping, and not identical (for example a 0900-1500 shift and a 1200-1700 shift by Joe Bloggs on the 23rd of March).
If this is possible then is it possible to do the check across workbooks (sometimes staff work in different departments, which have their own spreadsheets).
Furthermore is it possible to do this without VBA which hurts my poor brain.
Thank you
Dave
