Spreadsheet: 716958d1612436677-cycle-time-calculation-from-vehicle-entry-to-exit-cycle-time
Sheet: Sheet1

 |  | (time now)
Job No. | Vehicle No. | Destination | Vehicle Arrived (Date & Time) | Cycle Time (Hrs.) (From entry date & time to as of now) |  |  |  |  | Holidays (Including Sundays)
6112 | RJ01GB/2491 | SILWAMI | 2021-02-02 13:11:00 |  |  |  |  |  | 2021-01-03 00:00:00
80008 | TN37DF/9613 | COIMBATORE | 2021-01-30 15:23:00 |  |  |  |  |  | 2021-01-10 00:00:00
5979 | MH12LT/4958 | CHAKKAN | 2021-02-02 15:47:00 |  |  |  |  |  | 2021-01-17 00:00:00
6077 | RJ27GB/8791 | PIPARIYA | 2021-02-02 16:35:00 |  |  |  |  |  | 2021-01-24 00:00:00
 |  |  |  |  |  |  |  |  | 2021-01-31 00:00:00
 |  |  |  |  |  |  |  |  | 2021-02-07 00:00:00
 |  |  |  |  |  |  |  |  | 2021-02-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-02-21 00:00:00
 |  |  |  |  |  |  |  |  | 2021-02-28 00:00:00
 |  |  |  |  |  |  |  |  | 2021-03-07 00:00:00
 |  |  |  |  |  |  |  |  | 2021-03-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-03-21 00:00:00
 |  |  |  |  |  |  |  |  | 2021-03-28 00:00:00
 |  |  |  |  |  |  |  |  | 2021-04-04 00:00:00
 |  |  |  |  |  |  |  |  | 2021-04-11 00:00:00
 |  |  |  |  |  |  |  |  | 2021-04-18 00:00:00
 |  |  |  |  |  |  |  |  | 2021-04-25 00:00:00
 |  |  |  |  |  |  |  |  | 2021-05-02 00:00:00
 |  |  |  |  |  |  |  |  | 2021-05-09 00:00:00
 |  |  |  |  |  |  |  |  | 2021-05-16 00:00:00
 |  |  |  |  |  |  |  |  | 2021-05-23 00:00:00
 |  |  |  |  |  |  |  |  | 2021-05-30 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-06 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-13 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-20 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-27 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-11 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-18 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-25 00:00:00
 |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  |  |  |  |  | 2021-08-08 00:00:00
 |  |  |  |  |  |  |  |  | 2021-08-15 00:00:00
 |  |  |  |  |  |  |  |  | 2021-08-22 00:00:00
 |  |  |  |  |  |  |  |  | 2021-08-29 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-05 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-12 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-19 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-26 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-03 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-10 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-17 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-24 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-31 00:00:00
 |  |  |  |  |  |  |  |  | 2021-11-07 00:00:00
 |  |  |  |  |  |  |  |  | 2021-11-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-11-21 00:00:00
 |  |  |  |  |  |  |  |  | 2021-11-28 00:00:00
 |  |  |  |  |  |  |  |  | 2021-12-05 00:00:00
 |  |  |  |  |  |  |  |  | 2021-12-12 00:00:00
 |  |  |  |  |  |  |  |  | 2021-12-19 00:00:00
 |  |  |  |  |  |  |  |  | 2021-12-26 00:00:00
 |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2021-01-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-01-26 00:00:00
 |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00
 |  |  |  |  |  |  |  |  | 2021-05-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-10 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-02 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-15 00:00:00
 |  |  |  |  |  |  |  |  | 2021-11-04 00:00:00
 |  |  |  |  |  |  |  |  | 2021-12-25 00:00:00