Spreadsheet: 149655d1334071583-solved-time-format-average-inconsistency-logistics2
Sheet: log

name | wo | shift | date | group | focus factory | work order type | delay code | time | comment | delay code 2 | delay time 2 | comment 2 | delay code 3 | delay time 3 | comment 3 | delay code 4 | delay time 4 | comment 4 | total delay time | wo total time | wo net time
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | n | cor | h | 00:15:00 | - | o | 00:10:00 | - | add-1 | 00:15:00 | construction activity permit | - | - | - |  | 10:00:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | n | cor | e | 00:10:00 | - | o | 00:10:00 | - | - | - | - | - | - | - |  | 11:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | s | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 03:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | s | cor | a | 00:20:00 | - | e | 00:15:00 | - | j | 00:10:00 | - | o | 00:05:00 | - |  | 10:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | v | cor | f | 00:30:00 | - | m | 02:00:00 | - | o | 01:30:00 | - | - | - | - |  | 11:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | v | bk | d | 02:00:00 | - | - | - | - | - | - | - | - | - | - |  | -
[NAME] Cougar | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | [NAME] | g | 00:30:00 | - | l | 00:30:00 | - | o | 00:30:00 | - | - | - | - |  | 06:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | n | [NAME] | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | n | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 05:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | PRO-3155 | n | - | j | - | - | p | 00:00:00 | - | - | - | - | - | - | - |  | -
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | v | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 02:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | s | pm | add-1 | 00:15:00 | looking for ladder | - | - | - | - | - | - | - | - | - |  | 02:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | bk | d | 00:10:00 | - | - | - | - | - | - | - | - | - | - |  | 00:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | cor | d | 00:10:00 | - | - | - | - | - | - | - | - | - | - |  | 00:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | cor | o | 00:30:00 | - | - | - | - | - | - | - | - | - | - |  | 01:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | cor | o | 00:50:00 | - | - | - | - | - | - | - | - | - | - |  | 02:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | s | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 02:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | v | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 03:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | v | bk | - | - | - | - | - | - | - | - | - | - | - | - |  | 04:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | v | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | v | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | v | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | other | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 02:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | other | [NAME] | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | n | [NAME] | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | n | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 00:30:00
 |  |  | 2012-04-03 00:00:00 |  |  | pm | - | -
 |  |  | 2012-04-04 00:00:00 |  |  |  | -
 |  |  | 2012-04-05 00:00:00 |  |  |  | -
 |  |  | 2012-04-06 00:00:00 |  |  |  | 0 | 0.5
 |  |  | 2012-04-07 00:00:00 |  |  |  | o | 4
 |  |  | 2012-04-08 00:00:00
 |  |  | 2012-04-09 00:00:00
 |  |  | 2012-04-10 00:00:00
 |  |  | 2012-04-11 00:00:00
 |  |  | 2012-04-12 00:00:00
 |  |  | 2012-04-15 00:00:00