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

 | [NAME] and fly-posting Statistics for April 2008
 | SUMMARY
 | Authorities
 | Total | W | A | West S
 |  |  |  | total | W | A
* | 2 | 0 | 2 | 0 | 0 | 0 | Total number of [NAME] incidents
 | 7 | 0 | 7 | 0 | 0 | 0 | Total quantity of graffiti removed in square meters
* | 0 | 0 | 0 | 0 | 0 | 0 | Total number of fly-posting incidents
 | 0 | 0 | 0 | 0 | 0 | 0 | Total number of fly-posters removed
* | 2 |  | Total number of Incidents
 | 2 | 1 | Total by "patrol"
 | 0 | 0 | Total by "report"
 |  | 1
 | TARGETS
 |  |  |  | [NAME]
 |  |  |  |  |  |  | Percentages
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Total | Each | Running
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed same day
 | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 1 working day
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 2 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 3 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 4 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 5 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents taking longer than 5 working days | Incidents taking longer than 5 working days
 | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | Totals
 | TARGETS
 |  |  |  | FLY-POSTING
 |  |  |  |  |  |  | Percentages
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Total | Each | Running
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed same day
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 1 working day
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 2 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 3 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 4 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents completed in 5 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Incidents taking longer than 5 working days | Incidents taking longer than 5 working days
 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | Totals
 | 0 |  | Total number of offensive reports for the month
 | 0 | #N/A | Number of offensive reports that were completed within 1 day
 | 0 | #N/A | Number of offensive reports that were completed in longer than 1 day
 | DETAILS
 | Total number of graffiti incidents |  |  |  |  |  |  | Total | Rac / Offensive
 |  | ANO | WS | 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
 |  | ANO | WS | 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
 |  | ANO | WS | 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
 |  | ANO | WS | 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
 |  |  |  |  |  | Rac = Racist