Hi folks,
I've searched around and not been able to find a solution for this.
My workplace uses a spreadsheet for rostering which I've been incorporating error checking into.
On this roster a person may be put in separate departments on the same day, but the start and finish time that're input need to be the same.
What I currently have is a set of five start and finish times (one for each department) returned for each person on the roster, where 0 is returned if the person isn't rostered in that department.
I want to compare each of these to one another returning true if the the start times are all equivalent and the finish times are all equivalent and values of 0 are ignored.
I know how to do this using nested if's, but I'm hoping that there may be some way around this.
Any help would be greatly appreciated!
Archon173
I've searched around and not been able to find a solution for this.
My workplace uses a spreadsheet for rostering which I've been incorporating error checking into.
On this roster a person may be put in separate departments on the same day, but the start and finish time that're input need to be the same.
What I currently have is a set of five start and finish times (one for each department) returned for each person on the roster, where 0 is returned if the person isn't rostered in that department.
I want to compare each of these to one another returning true if the the start times are all equivalent and the finish times are all equivalent and values of 0 are ignored.
I know how to do this using nested if's, but I'm hoping that there may be some way around this.
Any help would be greatly appreciated!
Archon173
