Spreadsheet: 101407d1299538736-creating-conditional-formulas-for-time-values-bar-graph
Sheet: WC 140311

 | Start | End | Hours | 06:00:00 | 06:15:00 | 06:30:00 | 06:45:00 | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00 | 23:15:00 | 23:30:00 | 23:45:00
name 1 | 10:00:00AM | 18:15:00 | 8.25
name 2 | 10:00:00AM | 18:15:00 | 8.25
name 3 | 09:00:00 | 17:00:00 | 8
name 4 | 06:15:00 | 14:30:00 | 8.25
name 5 | 12:00:00PM | 20:00:00 | 8
name 6 | 09:15:00 | 17:30:00 | 8.25
name 7 | 08:30:00 | 16:45:00 | 8.25
name 8 | 08:30:00 | 16:30:00 | 8
name 9 | 09:45:00 | 18:00:00 | 8.25
name 10 | 3:00:00PM | 23:00:00 | 8
name 11 | 3:15:00PM | 23:00:00 | 7.75
name 12 | 09:45:00 | 18:00:00 | 8.25
name 13 | 3:00:00PM | 23:00:00 | 8
name 14 | 6:00:00PM | 22:00:00 | 4
name 15 | 2:30:00PM | 22:30:00 | 8
name 16 | 10:30:00AM | 18:45:00 | 8.25
name 17 | 3:00:00PM | 23:00:00 | 8
name 18 | 08:00:00 | 16:00:00 | 8
name 19 | 3:00:00PM | 23:00:00 | 8
name 20 | 06:00:00 | 14:00:00 | 8
name 21 | 08:30:00 | 15:15:00 | 6.75
name 22 | 12:00:00PM | 20:00:00 | 8
name 23 | 10:00:00AM | 18:15:00 | 8.25
name 24 | 3:15:00PM | 23:00:00 | 7.75
name 25 | 09:30:00 | 17:45:00 | 8.25
name 26 | 12:00:00PM | 20:00:00 | 8
name 27 | 09:30:00 | 17:30:00 | 8
name 28 | 09:15:00 | 17:15:00 | 8
name 29 | 09:15:00 | 17:30:00 | 8.25
name 30 | 12:00:00PM | 20:00:00 | 8
name 31 | 3:00:00PM | 23:00:00 | 8
name 32 | 09:15:00 | 17:30:00 | 8.25
name 33 | 09:30:00 | 17:45:00 | 8.25
name 34 | 06:00:00 | 14:00:00 | 8
name 35 | 08:30:00 | 16:45:00 | 8.25
name 36 | 06:00:00 | 14:00:00 | 8
name 37 | 06:00:00 | 14:00:00 | 8
name 38 | 08:45:00 | 16:45:00 | 8
name 39 | 11:45:00AM | 20:00:00 | 8.25
name 40 | 09:45:00 | 18:00:00 | 8.25
name 41 | 08:00:00 | 16:15:00 | 8.25
name 42 | 08:15:00 | 16:30:00 | 8.25
name 43 | 4:15:00PM | 1900-01-01 00:00:00 | 7.75
name 44 | 3:00:00PM | 23:00:00 | 8
name 45 | 10:00:00AM | 18:15:00 | 8.25
name 46 | 06:30:00 | 14:30:00 | 8
name 47 | 10:00:00AM | 18:00:00 | 8
name 48 | 08:00:00 | 16:15:00 | 8.25
name 49 | 3:00:00PM | 23:00:00 | 8
name 50 | 09:15:00 | 14:15:00 | 5
name 51 | 09:15:00 | 17:15:00 | 8
name 52 | 09:45:00 | 18:00:00 | 8.25
name 53 | 09:15:00 | 17:30:00 | 8.25
name 54 | 06:30:00 | 14:30:00 | 8
name 55 | 10:00:00AM | 18:15:00 | 8.25
name 56 | 7:00:00PM | 1900-01-01 00:00:00 | 5
name 57 | 08:30:00 | 14:30:00 | 6
name 58 | 09:15:00 | 15:15:00 | 6
name 59 | 06:00:00 | 14:00:00 | 8
name 60 | 11:00:00AM | 19:00:00 | 8
name 61 | 08:00:00 | 13:00:00 | 5
name 62 | 6:00:00PM | 23:00:00 | 5
name 63 | 08:00:00 | 16:00:00 | 8
name 64 | 09:30:00 | 17:30:00 | 8
name 65 | 1:00:00PM | 21:00:00 | 8
name 66 | 10:00:00AM | 18:15:00 | 8.25
name 67 | 06:00:00 | 14:00:00 | 8
name 68 | 10:30:00AM | 18:45:00 | 8.25
name 69 | 09:00:00 | 14:30:00 | 5.5
name 70 | 2:30:00PM | 22:30:00 | 8
name 71 | 09:30:00 | 17:30:00 | 8
name 72 | 08:45:00 | 16:45:00 | 8
name 73 | 10:00:00AM | 18:15:00 | 8.25
name 74 | 6:00:00PM | 22:00:00 | 4
name 75 | 08:15:00 | 16:30:00 | 8.25
name 76 | 09:00:00 | 17:00:00 | 8
name 77 | 12:00:00PM | 20:00:00 | 8
name 78 | 11:00:00AM | 19:00:00 | 8
name 79 | 11:45:00AM | 20:00:00 | 8.25
name 80 | 09:00:00 | 16:00:00 | 7
name 81 | 08:00:00 | 16:15:00 | 8.25
name 82 | 3:00:00PM | 23:00:00 | 8
name 83 | 10:30:00PM | 07:00:00 | 8.5
name 84 | 06:30:00 | 14:30:00 | 8
name 85 | 10:00:00AM | 18:15:00 | 8.25
name 86 | 08:45:00 | 16:45:00 | 8
name 87 | 09:30:00 | 17:45:00 | 8.25
name 88 | 08:45:00 | 16:45:00 | 8
name 89 | 08:00:00 | 16:00:00 | 8
name 90 | 3:00:00PM | 23:00:00 | 8
name 91 | 10:00:00AM | 18:15:00 | 8.25
name 92 | 08:30:00 | 16:45:00 | 8.25
name 93 | 09:30:00 | 14:15:00 | 4.75
name 94 | 09:00:00 | 17:00:00 | 8
name 95 | 09:00:00 | 17:00:00 | 8
name 96 | 08:30:00 | 16:45:00 | 8.25
name 97 | 09:30:00 | 17:45:00 | 8.25
name 98 | 09:15:00 | 17:30:00 | 8.25
name 99 | 09:00:00 | 17:00:00 | 8
name 100 | 3:00:00PM | 23:00:00 | 8
name 101 | 08:00:00 | 16:00:00 | 8
name 102 | 7:00:00PM | 1900-01-01 00:00:00 | 5
name 103 | 10:00:00AM | 18:00:00 | 8
name 104 | 08:45:00 | 17:00:00 | 8.25
name 105 | 08:00:00 | 16:15:00 | 8.25
name 106 | 10:30:00PM | 07:00:00 | 8.5
name 107 | 09:15:00 | 17:30:00 | 8.25
name 108 | 06:00:00 | 13:45:00 | 7.75
name 109 | 10:00:00AM | 18:15:00 | 8.25
name 110 | 09:30:00 | 17:45:00 | 8.25
name 111 | 09:15:00 | 14:15:00 | 5
name 112 | 11:45:00AM | 20:00:00 | 8.25
name 113 | 1:00:00PM | 21:00:00 | 8
name 114 | 08:00:00 | 16:15:00 | 8.25
name 115 | 6:00:00PM | 23:00:00 | 5
name 116 | 7:00:00PM | 1900-01-01 00:00:00 | 5
name 117 | 08:00:00 | 16:00:00 | 8
name 118 | 12:00:00PM | 20:00:00 | 8
name 119 | 12:00:00PM | 20:00:00 | 8
name 120 | 4:15:00PM | 1900-01-01 00:00:00 | 7.75
name 121 | 08:00:00 | 16:15:00 | 8.25
name 122 | 08:30:00 | 16:45:00 | 8.25