I'm going to attach a file that I would appreciate some help on. A little background first:
This file is a scheduling document made to import so the formatting of it's current data cannot change, however adding columns to the end and running formulae there is fine. There are no issues with this scheduling document, but when importing sometimes the importing tool finds a mistype where the finish time is before the start time (I/E Start time is 9am and the End time is 6am but should be 6pm) and will not import... the problem there is that now I'm stuck with determining where that error actually is in the document and correcting it. To compound this issue, the time is in text format, and no matter what I do (TIMEVALUE,TEXT,etc) it will not convert to a actual time. Converting to the time is my way of attempting a solution, so it may not be the best solution and I'm open to suggestions there. But to sum up, I need something that:
- looks at the Start Date compared to the End Date to confirm they match or the END date is only 1 day later
- looks at the Start Time compared to the Finish Time to confirm that the Finish Time does not come before the start time
This may be confusing, I'm not sure, but the people who answer here are generally smarter than me and figure it out lol. I thank you in advance, if you have any questions to clear it up I would be happy to answer.
NOTE: the site won't take a CSV file, but the file has to be CSV to import, I've attached a XLSX file.