Spreadsheet: 179718d1347365330-copy-and-paste-formatting-problem-copy-and-paste-problem
Sheet: Mon-Thurs Duty Times

First
Days: MON,TUE,WED,THU |  |  |  | Commence: 11/06/2012 Ref: 31E1 |  |  |  | Depot: BR
 | Schooldays
Crew Duty Value List
Duty | Sign | Sign | Meal/Split | Unpaid | Actual | Duty | Paid | Duty | Drive | DrvlDty
No | On | Off | Breaks | Break | Break | S/O | Time | Time | Time | time %
101 | 0512 | 1236 | 1030-1112 | 0:42 |  | 7:24 | 6:42 | 6:42 | 3:57 | 58.96%
102 | 0530 | 1308 | 1018-1057 | 0:39 |  | 7:38 | 6:59 | 6:59 | 5:51 | 83.77%
103 | 0550 | 1308 | 0952-1042 | 0:50 | 0:54 | 7:18 | 6:30 | 6:28 | 5:06 | 78.87%
104 | 0557 | 1308 | 1033-1122 | 0:49 |  | 7:11 | 6:30 | 6:22 | 5:12 | 81.68%
105 | 0610 | 1350 | 1015-1047 | 0:32 |  | 7:40 | 7:08 | 7:08 | 5:33 | 77.80%
106 | 0615 | 1424 | 0922-1012 | 0:50 | 0:59 | 8:09 | 7:19 | 7:19 | 6:09 | 84.05%
107 | 0615 | 1424 | 1027-1117 | 0:50 |  | 8:09 | 7:19 | 7:19 | 5:27 | 74.49%
108 | 0620 | 1520 | 0932-1022 | 0:50 | 1:08 | 9:00 | 8:10 | 8:10 | 5:39 | 69.18%
109 | 0620 | 1520 | 1058-1148 | 0:50 | 1:00 | 9:00 | 8:10 | 8:10 | 6:33 | 80.20%
110 | 0642 | 1520 | 1114-1157 | 0:43 |  | 8:38 | 7:55 | 7:55 | 6:35 | 83.16%
111 | 0645 | 1608 | 1058-1142 | 0:44 |  | 9:23 | 8:39 | 8:39 | 7:05 | 81.89%
112 | 0650 | 1608 | 1127-1217 | 0:50 | 0:59 | 9:18 | 8:28 | 8:28 | 6:14 | 73.62%
113 | 0655 | 1608 | 0859-0949 | 0:50 | 1:01 | 9:13 | 8:23 | 8:23 | 5:58 | 71.17%
114 | 0700 | 1608 | 1018-1057 | 0:39 |  | 9:08 | 8:29 | 8:29 | 6:03 | 71.32%
115 | 0700 | 1646 | 1148-1227 | 0:39 |  | 9:46 | 9:07 | 9:07 | 7:52 | 86.29%
116 | 0707 | 1728 | 1122-1212 | 0:50 | 0:57 | 10:21 | 9:31 | 9:31 | 7:00 | 73.56%
117 | 0715 | 1740 | 1237-1327 | 0:50 | 1:09 | 10:25 | 9:35 | 9:35 | 7:43 | 80.52%
118 | 0730 | 1805 | 1227-1317 | 0:50 |  | 10:35 | 9:45 | 9:45 | 8:19 | 85.30%
119 | 0730 | 1821 | 1157-1247 | 0:50 | 1:14 | 10:51 | 10:01 | 10:01 | 6:58 | 69.55%
120 | 0751 | 1830 | 1433-1522 | 0:49 |  | 10:39 | 9:50 | 9:50 | 7:18 | 74.24%
121 | 0752 | 1852 | 1304-1347 | 0:43 |  | 11:00 | 10:17 | 10:17 | 8:13 | 79.90%
122 | 0911 | 1835 | 1348-1427 | 0:39 |  | 9:24 | 8:45 | 8:45 | 7:09 | 81.71%
123 | 0911 | 1945 | 1402-1452 | 0:50 | 1:25 | 10:34 | 9:44 | 9:44 | 7:40 | 78.77%
124 | 0911 | 1950 | 1352-1442 | 0:50 | 1:24 | 10:39 | 9:49 | 9:49 | 7:26 | 75.72%
125 | 1001 | 1948 | 1518-1557 | 0:39 |  | 9:47 | 9:08 | 9:08 | 6:51 | 75.00%
126 | 1001 | 2005 | 1432-1522 | 0:50 | 1:04 | 10:04 | 9:14 | 9:14 | 7:33 | 81.77%
127 | 1156 | 2000 | 1612-1702 | 0:50 | 0:58 | 8:04 | 7:14 | 7:14 | 5:28 | 75.58%
128 | 1255 | 1950 | 1504-1542 | 0:38 |  | 6:55 | 6:30 | 6:17 | 5:04 | 80.64%
129 | 1255 | 2008 | 1432-1522 | 0:50 | 0:52 | 7:13 | 6:30 | 6:23 | 4:57 | 77.55%
130 | 1255 | 2028 | 1737-1827 | 0:50 | 1:00 | 7:33 | 6:43 | 6:43 | 5:20 | 79.40%
131 | 1255 | 2040 | 1645-1727 | 0:42 |  | 7:45 | 7:03 | 7:03 | 5:56 | 84.16%
132 | 1436 | 2345 | 1920-2007 | 0:47 |  | 9:09 | 8:22 | 8:22 | 6:52 | 82.07%
133 | 1436 | 2357 | 1948-2027 | 0:39 |  | 9:21 | 8:42 | 8:42 | 7:21 | 84.48%
134 | 1436 | 2345 | 1907-1957 | 0:50 | 0:53 | 9:09 | 8:19 | 8:19 | 6:40 | 80.16%
135 | 1529 | 0005 | 1850-1937 | 0:47 |  | 8:36 | 7:49 | 7:49 | 6:34 | 84.01%
136 | 1529 | 0010 | 1848-1937 | 0:49 |  | 8:41 | 7:52 | 7:52 | 5:49 | 73.94%
137 | 1529 | 0019 | 2017-2107 | 0:50 | 1:09 | 8:50 | 8:00 | 8:00 | 6:08 | 76.67%
138 | 1607 | 0019 | 1827-1907 | 0:40 |  | 8:12 | 7:32 | 7:32 | 5:50 | 77.43%
151 | 0559 | 1308 | 1013-1057 | 0:44 |  | 7:09 | 6:30 | 6:25 | 4:43 | 73.51%
152 | 0716 | 1608 | 1113-1157 | 0:44 |  | 8:52 | 8:08 | 8:08 | 5:44 | 70.49%
153 | 0930 | 1922 | 1513-1557 | 0:44 |  | 9:52 | 9:08 | 9:08 | 6:21 | 69.53%
154 | 1436 | 2356 | 1910-1949 | 0:39 |  | 9:20 | 8:41 | 8:41 | 6:10 | 71.02%
Totals: |  |  |  |  |  |  | 344:30 | 343:55 | 266:21 | 77.45%
RD
RD1
RD2
RD3
RD4
RD5
RD6
RD7
RD8
RD9
RD10
RD11
RD12
[NAME]
RD14
RD15
RD16
RD17
RD18
RD19
SAD