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