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