Try something like:

=IF(B1-A1<=TIME(2,,),"Within Two Hours",IF(B1-A1<=TIME(4,,),"Within Four
Hours","Over Four Hours"))

Where the Start time is in A1 and the Resolution time is in B1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"bluesifi" wrote in message
...
Hi

I need to measure performance of incidents based on resolution times, but
I
am having problem working out how to do this.

I have 2 columns in a sheet:-
Start (dd/mm/yy hh:mm format) which shows when the incident was raised
Actual (dd/mm/yy hh:mm format) which shows actual resolution time.

I want to measure performance against primary and secondary resolution
times. I want Primary to show if it was resolved within 2 hours of being
raise, and Secondary to show if it was resolved with 4 working hours.

Is this possible, if so what formula should I use.

thanks

Joanne