If Class A and D are mandatory, how can I have a column for the optional classes (B and C in this case) to tell if there is a conflict for any of the mandatory classes? I've tried IF Statements, but it won't work that well.
http://imgur.com/tlAJ46h
If Class A and D are mandatory, how can I have a column for the optional classes (B and C in this case) to tell if there is a conflict for any of the mandatory classes? I've tried IF Statements, but it won't work that well.
http://imgur.com/tlAJ46h
that should work. I've cheated a bit by using the 24 hrs format.
![]()
Please Login or Register to view this content.
Last edited by AlanY; 11-21-2014 at 07:18 AM.
Thank you AlanY, but this is just a small sample size of the actual data and I was hoping for dates to also be included. Is there a function for this aspect?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks