Hi,
I have a spreadsheet, which has a column which has "time between two times" in it.
What I need to do is work out a SLA Pass or Fail column
Column A - 04:10:00
Column B - 8
Column C - 4
Column D - Printer
Column E - 1 or 2
I have worked out a cell to produce 1 or 2 if the row is in a chosen category.
e.g if category is Printer the SLA is 4 hours so the cell has 2 in it
What I need to do based on this is if Column A is greater then 4 hours you get a fail.
But the driving condition needs to be column D as some categories have a SLA of 8 hours. so if less then 8 they shouldn't fail.
Hope this makes sense
Thanks
Bookmarks