Spreadsheet: 134914d1325701348-converting-time-and-conditional-formatting-ips-cal-time
Sheet: Sheet1

Job Number | Language | Booking Start Date | Booking Finish Date | Duration | Venue | Project Reference | Interviewee Ref | Total Client Charge GBP |  | Time | Time In Duration
 |  | 2011-12-16 09:00:00 | 2011-12-16 10:00:00 | 1 |  |  |  |  | 01:00:00 | 0.5999999999650755 | 1 | 0.9999999999417923 | 0.5999999999650755
 |  | 2011-12-21 09:55:00 | 2011-12-21 12:05:00 | 2.17 |  |  |  |  | 02:10:00 | 2.099999999941792 | 2.102 | 2.166666666569654 | 2.099999999941792
 |  | 2011-12-21 12:10:00 | 2011-12-21 16:45:00 | 4.58 |  |  |  |  | 04:35:00 | 4.349999999953434 | 4.348 | 4.583333333255723 | 4.349999999953434
 |  | 2011-12-24 11:45:00 | 2011-12-24 12:15:00 | 0.5 |  |  |  |  | 00:30:00 | 0.3000000000349246 | 0.3 | 0.5000000000582077 | 0.3000000000349246
 |  | 2011-12-22 09:15:00 | 2011-12-22 15:15:00 | 6 |  |  |  |  | 06:00:00 | 6 | 6 | 6 | 6
 |  | 2011-12-14 12:08:00 | 2011-12-14 16:14:00 | 4.1 |  |  |  |  | 04:06:00 | 4.060000000055879 | 4.06 | 4.100000000093132 | 4.060000000055879
 |  | 2011-12-23 11:00:00 | 2011-12-23 11:33:00 | 0.55 |  |  |  |  | 00:33:00 | 0.3300000000279397 | 0.33 | 0.5500000000465661 | 0.3300000000279397
 |  | 2011-12-19 10:15:00 | 2011-12-19 12:15:00 | 2 |  |  |  |  | 02:00:00 | 2.000000000034925 | 2 | 2.000000000058208 | 2.000000000034925
 |  | 2011-12-21 09:20:00 | 2011-12-21 16:45:00 | 7.42 |  |  |  |  | 07:25:00 | 7.249999999941792 | 7.252 | 7.416666666569654 | 7.249999999941792
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00