Hello, I want a formula which calculates wether a timeschale has been hit or not. I already have one in place which calculates the days, hours & minutes it has taken to complete a task from a start and finish date but then then the target time is sometimes in working hours or days. So, i need the formula to take working hours and days into account.
Is there a way of doing this? Can you please help?

Here is an example of the excel table i'm working with. Hopefully this will paste correctly in excel. Any help would be greatly appreciated.

Time for fix SLA Fix SLA failed Time for Update SLA Update SLA failed Date Opened Date Responded Date Closed Priority
1 27 Days, 6 Hours, 18 Minutes 5 w/days Y 0 Days, 0 Hours, 0 Minutes 04/08/2011 10:21 04/08/2011 10:21 31/08/2011 16:40 4
2 36 Days, 2 Hours, 38 Minutes 5 w/days Y 0 Days, 0 Hours, 1 Minutes 26/07/2011 13:47 26/07/2011 13:48 31/08/2011 16:24 4
3 51 Days, 6 Hours, 42 Minutes 5 w/days Y 1 Days, 0 Hours, 1 Minutes 11/07/2011 09:41 12/07/2011 09:42 31/08/2011 16:24 4
4 5 Days, 5 Hours, 10 Minutes 10 w/hrs Y 0 Days, 0 Hours, 5 Minutes 05/08/2011 10:02 05/08/2011 10:07 10/08/2011 15:12 3
5 7 Days, 4 Hours, 58 Minutes 5 w/days Y 0 Days, 0 Hours, 0 Minutes 03/08/2011 09:28 03/08/2011 09:28 10/08/2011 14:26 4
6 0 Days, 5 Hours, 29 Minutes 30 days N 0 Days, 5 Hours, 29 Minutes 15/08/2011 11:00 15/08/2011 16:30 15/08/2011 16:30 Non Standard
7 0 Days, 9 Hours, 15 Minutes 10 hrs N 0 Days, 0 Hours, 0 Minutes 2 hrs N 04/08/2011 01:30 04/08/2011 01:30 04/08/2011 10:45 2
8 1 Days, 13 Hours, 17 Minutes 10 w/hrs Y 0 Days, 0 Hours, 0 Minutes 30/08/2011 08:21 30/08/2011 08:21 31/08/2011 21:39 3
9 0 Days, 2 Hours, 59 Minutes 10 w/hrs N 0 Days, 0 Hours, 0 Minutes 31/08/2011 07:45 31/08/2011 07:45 31/08/2011 10:43 3
10 0 Days, 5 Hours, 38 Minutes 5 w/days N 0 Days, 5 Hours, 38 Minutes 30/08/2011 09:01 30/08/2011 14:39 30/08/2011 14:39 4
11 0 Days, 0 Hours, 2 Minutes 10 w/hrs N 0 Days, 0 Hours, 0 Minutes 01/08/2011 09:20 01/08/2011 09:20 01/08/2011 09:22 3
12 200 Days, 20 Hours, 42 Minutes 10 w/hrs Y 0 Days, 0 Hours, 1 Minutes 27/01/2011 13:53 27/01/2011 13:54 16/08/2011 10:35 3