Spreadsheet: 196827d1354118075-sumif-function-using-a-drop-list-utilisation
Sheet: Consultant Utilisation

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:35:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:05:00
 |  | 03:30:00 | THEATRE 1 |  |  | THEATRE 2 |  |  | THEATRE 4 |  |  | THEATRE 5 |  |  | THEATRE A |  |  | THEATRE B |  |  | THEATRE C |  |  |  |  | Name 1
 |  | MONDAY | Name 1 |  |  | Name 1 |  |  | Name 1 |  |  | Name 1 |  |  | Name 1 |  |  | Name 1 |  |  | Name 1 |  |  |  |  | Name 2
 |  | 2012-11-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 4
 |  |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  |  | Name 5
 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  |  |  | Name 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 8
 |  |  |  | 04:06:00 |  |  | 04:06:00 |  |  | 04:06:00 |  |  | 04:06:00 |  |  | 04:06:00 |  |  | 04:06:00 |  |  | 04:06:00 |  |  |  | Name 9
 |  | TUESDAY | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  |  |  | Name 10
 |  | 2012-11-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 12
 |  |  |  | 08:10:00 |  |  | 08:10:00 |  |  | 08:10:00 |  |  | 08:10:00 |  |  | 08:10:00 |  |  | 08:10:00 |  |  | 08:10:00 |  |  |  | Name 13
 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  |  |  | Name 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 16
 |  |  |  | 04:01:00 |  |  | 04:01:00 |  |  | 04:01:00 |  |  | 04:01:00 |  |  | 04:01:00 |  |  | 04:01:00 |  |  | 04:01:00 |  |  |  | Name 17
 |  | WEDNESDAY | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  |  |  | Name 18
 |  | 2012-11-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 20
 |  |  |  | 00:26:00 |  |  | 00:26:00 |  |  | 00:26:00 |  |  | 00:26:00 |  |  | 00:26:00 |  |  | 00:26:00 |  |  | 00:26:00
 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5
 |  |  |  | 06:22:00 |  |  | 06:22:00 |  |  | 06:22:00 |  |  | 06:22:00 |  |  | 06:22:00 |  |  | 06:22:00 |  |  | 06:22:00
 |  | THURSDAY | Name 2 |  |  | Name 2 |  |  | Name 2 |  |  | Name 2 |  |  | Name 2 |  |  | Name 2 |  |  | Name 2
 |  | 2012-11-29 00:00:00
 |  |  |  | 02:14:00 |  |  | 02:14:00 |  |  | 02:14:00 |  |  | 02:14:00 |  |  | 02:14:00 |  |  | 02:14:00 |  |  | 02:14:00
 |  |  | Name 8 |  |  | Name 8 |  |  | Name 8 |  |  | Name 8 |  |  | Name 8 |  |  | Name 8 |  |  | Name 8
 |  |  |  | 09:01:00 |  |  | 09:01:00 |  |  | 09:01:00 |  |  | 09:01:00 |  |  | 09:01:00 |  |  | 09:01:00 |  |  | 09:01:00
 |  | FRIDAY | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5 |  |  | Name 5
 |  | 2012-11-30 00:00:00
 |  |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00 |  |  | 03:30:00
 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4 |  |  | Name 4
 |  |  |  | 05:04:00 |  |  | 05:04:00 |  |  | 05:04:00 |  |  | 05:04:00 |  |  | 05:04:00 |  |  | 05:04:00 |  |  | 05:04:00