#### scottishmovies

##### Board Regular

- Joined
- Mar 11, 2003

- Messages
- 158

Hi All,

I want to calculate against two dates/times to measure response times.

I need to be able to calculate against the work day (exclude Weekends) and the working time (exclude times outwith working) and subtract one from the other to arrive at a severity level. This is to measure if we have acheived a proper timely response. Is this feasible in Excel? What is the formula I needd to put in Col D to make this work?

Hope someone can help as it's driving me nuts!

Thanks in advance,

Pat

I want to calculate against two dates/times to measure response times.

I need to be able to calculate against the work day (exclude Weekends) and the working time (exclude times outwith working) and subtract one from the other to arrive at a severity level. This is to measure if we have acheived a proper timely response. Is this feasible in Excel? What is the formula I needd to put in Col D to make this work?

Hope someone can help as it's driving me nuts!

Thanks in advance,

Pat

Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | |||

1 | ||||||||

2 | Work Days = Mon-Fri | Work Times = 08:30 - 17:30 | ||||||

3 | ||||||||

4 | Severity Level | |||||||

5 | A | <4 hours | ||||||

6 | B | > 4 hours<8 hours | ||||||

7 | C | > 8 hours< 1 week | ||||||

8 | D | > 1 week | ||||||

9 | ||||||||

10 | Date 1 | Date 2 | Expected response | |||||

11 | 1 | 01/03/2011 12:00 | 01/03/2011 15:15 | A | ||||

12 | 2 | 01/03/2011 12:00 | 01/03/2011 16:15 | B | ||||

13 | 3 | 01/03/2011 12:00 | 02/03/2011 14:00 | C | ||||

14 | 4 | 01/03/2011 12:00 | 07/03/2011 12:00 | D | ||||

15 | 5 | 05/03/2011 16:00 | 07/03/2011 09:00 | A | ||||

16 | 6 | 05/03/2011 16:30 | 07/03/2011 12:30 | B | ||||

17 | ||||||||

Sheet1 |

**Excel 2007**
Last edited: