Thanks for the response, they work.

If I then want to change this and break down between High & Medium, which
have different SLA (ie High the primary target is 2 hours and Medium the
primary target is 4 hours) and the result is Yes or No

A1 B1 C1
D1
Actual Resolution Status
Primary
12/01/06 11:56 13/01/06 12:56 Medium No
11/01/06 14:56 11/01/06 15:59 High Yes

I would like to have a column for Primary and another for Secondary. Can I
have a nesting formula to say If C1 = High then IF((B1-A1)<(2/24) else If C1
= Medium then IF((B1-A1)<(4/24)

Hope you understand

regards

Joanne