I have attached a some data I need help on. On the left I have manually written some MET's and FAILED.
These MET's and FAILED are based on a 1hr SLA that I want to automate for a Help Desk
The SLA is: From the Create Time "Column 3" a Help Desk Analyst has 1 hours to log the ticket, this is specified in Column E "Time Logged".
What I want to do is automate the MET or FAILED in column A and highlight the fails rather than go through thousands of tickets manually. So a failed would be if the time logged is 1+ hour after the time created.
The only problem is the format. The cells have the date before the time. I have tried to seperate them using Data\Text to COlumns but with no luck.
I would prefer a formula rather than Macro but am desperate.