Spreadsheet: 35303d1232897100-how-do-i-calculate-time-between-2-dates-times-subtracting-the-time-over-weekends-example-01
Sheet: Week 1

Joint Authorities of W, A and West S - Graffiti analysis |  |  |  |  |  |  |  |  |  |  |  | Days taken to clean - G | Days taken to clean - F | A N Other | West S | Councils | Commercial | Statutory Undertaker | Domestic
Week commencing: 1st April 2008
Date | Reported | Address/Location/Road | Phone & | Racist or | Property | Graffiti/Tag | Exact time | Removal | M² | Photos | Date
Reported | By - Name | Property/Name/Number | E Mail | Offensive | Type | Surface | [NAME] (mins) | Type |  |  | Cleared
2008-03-31 00:00:00 | Patrol |  |  | No | Wall | Black/yellow sprays | 20 | PW | 3 | 0001-0002 | 2008-04-01 00:00:00 | 1 |  |  |  |  | a
2008-03-31 00:00:00 | Patrol |  |  | No | Electric box | Black/blue sprays | 47 | CH | 4 | 0003-0006 | 2008-04-01 00:00:00 | 1 |  |  |  |  |  | a
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Number of fly posting incidents this week: |  |  | 0 |  |  |  |  |  | 0 |  | Total completed on the same day
 |  |  | Number of fly posters removed this week: |  |  | 0 |  |  |  |  |  | 2 |  | Total completed within 1 day
 |  |  | Number of graffiti incidents this week: |  |  | 2 |  |  |  |  |  | 0 |  | Total completed within 2 days
 |  |  | Total square metres of graffiti cleaned this week: |  |  | 7 |  |  |  |  |  | 0 |  | Total completed within 3 days
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed within 4 days
 |  |  | Any cells that are yellow indicate that they have taken too long to clean. Please investigate why. Pink cells are for highlighting Racist / Offensive incidents. |  |  |  |  |  |  |  |  | 0 |  | Total completed within 5 days
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed > 5 days
 |  |  |  |  |  |  |  |  |  |  |  | Fly-poster targets
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed on the same day
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed within 1 day
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed within 2 days
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed within 3 days
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed within 4 days
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed within 5 days
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Total completed > 5 days
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Offensive completed Within 1 day
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Offensive taken longer than 1 day
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | Patrol reports
 |  |  |  |  |  |  |  |  |  |  |  | Total number of graffiti incidents |  |  |  |  |  |  |  | Total | Rac / Offensive
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VM | WSCC | Coun | Comm | SU | Dom
 |  |  |  |  |  |  |  |  |  |  |  | Wg |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Adur |  | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Total amount of graffiti in square metres |  |  |  |  |  |  |  | Total | Rac / Offensive
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VM | WSCC | Coun | Comm | SU | Dom
 |  |  |  |  |  |  |  |  |  |  |  | Wg |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Adur |  | 0 | 0 | 0 | 3 | 4 | 0 | 7 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 3 | 4 | 0 | 7 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Total number of fly-posting incidents |  |  |  |  |  |  |  | Total | Rac / Offensive
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VM | WSCC | Coun | Comm | SU | Dom
 |  |  |  |  |  |  |  |  |  |  |  | Wg |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Adur |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Total amount of fly-posters cleared |  |  |  |  |  |  |  | Total | Rac / Offensive
 |  |  |  |  |  |  |  |  |  |  |  |  |  | VM | WSCC | Coun | Comm | SU | Dom
 |  |  |  |  |  |  |  |  |  |  |  | Wg |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Adur |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0