Hello all,
Thanks for the help in advance.
I've attached a snippet of my table. I have Arrival Time and Completion Time. I have the difference in the 2 dates/times calculated, now I need to see if we arrived and completed the call in the time given. I was trying to do an =IF(AND( but I have 5 different "priorities" or times given to arrive and complete each call. These times are listed to the right of the table. Say I have a priority 2, I need to be on site in 4 hours and completed in 8, I can get this formula to work but when the data in imported I need the table to find the priority and times given and arrival time/completion time. I hope this is fairly clear and I appreciate the help.
Call Log Test.xlsx
Bookmarks