Spreadsheet: 217901d1362245923-sum-the-time-in-hours-minutes-based-on-selection-in-drop-down-list-tracking-log
Sheet: Puchases Log

 | Hours Tracking Log
 | Security Related
 |  |  |  |  |  |  | Total [NAME]: |  |  | Total PI Hours:
 | March
 | DATE | Equipment | REASON | Time Comp Started | Time Comp Stopped | Total Time | PIP If Applicable | W/R # If Applicable | Comments |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | PI
 | 2013-03-04 00:00:00 | PA CCTV | Wind | 00:15:00 | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | PA IDS |  | 2013-03-01 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Rain | 00:05:00 | 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | PA CCTV |  | 2013-03-02 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Video Capture |  | 2013-03-03 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vital Door |  | 2013-03-04 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCA CCTV |  | 2013-03-05 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCA VBS |  | 2013-03-06 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radios |  | 2013-03-07 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2013-03-08 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Locks |  | 2013-03-09 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Telephones |  | 2013-03-10 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-11 00:00:00
 | 2013-03-04 00:00:00 | PA CCTV | Alarm Inop – No Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alarm Inop – No Alarm |  |  | 2013-03-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to Normal |  |  | 2013-03-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Continuous Intrusion Alarm |  |  | 2013-03-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 2013-03-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Continuous Supervision Alarm |  |  | 2013-03-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 2013-03-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV Inop – No Picture |  |  | 2013-03-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV Inop – Inadequate Picture |  |  | 2013-03-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Will Not Lock |  |  | 2013-03-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fog |  |  | 2013-03-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rain |  |  | 2013-03-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wind |  |  | 2013-03-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sun |  |  | 2013-03-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Birds |  |  | 2013-03-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Animals |  |  | 2013-03-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debris |  |  | 2013-03-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 2013-03-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00