Spreadsheet: 680524d1591077703-if-formula-with-time-function-raport-auchan-copy
Sheet: Timeframe

 | [NAME] camion | Magazin | KM | Ora Min | Average | [NAME] | Plecare | Timp |  |  | Durata Descarcare |  | FT | D1 | [NAME]
 |  | Satu Mare | 654 | 12:00:00 |  | 14:00:00 | 17:00:00 | 15:30:00 |  |  | 01:00:00 |  | ST | D0 | Grupaj Metro
 |  | Baia Mare | 587 | 08:00:00 |  | 10:00:00 | 17:00:00 | 15:00:00 |  |  |  |  | TT |  | Satu Mare
 |  | [NAME] | 581 | 11:00:00 |  | 13:00:00 | 17:30:00 | 14:30:00 |  |  |  |  |  |  | Baia Mare
 |  | [NAME] | 581 | 08:00:00 |  | 10:00:00 | 17:30:00 | 14:30:00 |  |  |  |  |  |  | [NAME]
 |  | [NAME] | 581 | 08:00:00 |  | 10:00:00 | 17:30:00 | 14:30:00 |  |  |  |  |  |  | [NAME]
 |  | Oradea | 604 | 08:00:00 |  | 10:00:00 | 17:00:00 | 15:00:00 |  |  |  |  |  |  | [NAME]
 |  | Militari | 10 | 16:00:00 |  | 18:00:00 | 14:00:00 | 02:00:00 |  |  |  |  |  |  | Oradea
 |  | Pallady | 30 | 19:00:00 |  | 21:00:00 | 17:30:00 | 01:30:00 |  |  |  |  |  |  | Militari
 |  | Crangasi | 10 | 19:00:00 |  | 21:00:00 | 17:00:00 | 02:00:00 |  |  |  |  |  |  | Pallady
 |  | Berceni | 20 | 19:00:00 |  | 21:00:00 | 17:00:00 | 02:00:00 |  |  |  |  |  |  | Crangasi
 |  | [NAME] | 10 | 19:00:00 |  | 21:00:00 | 17:00:00 | 02:00:00 |  |  |  |  |  |  | Berceni
 |  | Cotroceni | 10 | 20:00:00 |  | 22:00:00 | 18:00:00 | 02:00:00 |  |  |  |  |  |  | [NAME]
 |  | Vitan | 25 | 20:00:00 |  | 22:00:00 | 18:00:00 | 02:00:00 |  |  |  |  |  |  | Cotroceni
 |  | Titan | 30 | 20:00:00 |  | 22:00:00 | 18:00:00 | 01:00:00 |  |  |  |  |  |  | Vitan
 |  | [NAME] | 466 | 10:00:00 |  | 12:00:00 | 19:30:00 | 11:30:00 |  |  |  |  |  |  | Titan
 |  | [NAME] | 466 | 07:00:00 |  | 09:00:00 | 19:30:00 | 11:30:00 |  |  |  |  |  |  | [NAME]
 |  | Targu Mures Istoric | 379 | 11:00:00 |  | 13:00:00 | 22:30:00 | 08:30:00 |  |  |  |  |  |  | [NAME]
 |  | Targu [NAME] | 379 | 07:00:00 |  | 09:00:00 | 22:30:00 | 08:30:00 |  |  |  |  |  |  | Targu Mures Istoric
 |  | Deva | 412 | 16:00:00 |  | 18:00:00 | 23:00:00 | 09:30:00 |  |  |  |  |  |  | Targu [NAME]
 |  | [NAME] | 296 | 06:00:00 |  | 08:00:00 | 23:00:00 | 07:00:00 |  |  |  |  |  |  | Deva
 |  | Iasi | 416 | 06:00:00 |  | 08:00:00 | 21:00:00 | 09:00:00 |  |  |  |  |  |  | [NAME]
 |  | [NAME] | 269 | 09:00:00 |  | 11:00:00 | 1900-01-01 04:00:00 | 05:00:00 |  |  |  |  |  |  | Iasi
 |  | [NAME] | 457 | 12:00:00 |  | 14:00:00 | 1900-01-01 02:30:00 | 09:30:00 |  |  |  |  |  |  | [NAME]
 |  | Bacau | 304 | 09:00:00 |  | 11:00:00 | 1900-01-01 02:30:00 | 06:30:00 |  |  |  |  |  |  | [NAME]
 |  | [NAME] | 291 | 09:00:00 |  | 11:00:00 | 1900-01-01 01:00:00 | 05:00:00 |  |  |  |  |  |  | Bacau
 |  | [NAME] | 291 | 06:00:00 |  | 08:00:00 | 1900-01-01 01:00:00 | 05:00:00 |  |  |  |  |  |  | [NAME]
 |  | [NAME] | 254 | 09:00:00 |  | 11:00:00 | 1900-01-01 04:00:00 | 05:00:00 |  |  |  |  |  |  | [NAME]
 |  | [NAME] | 254 | 09:00:00 |  | 11:00:00 | 1900-01-01 04:00:00 | 05:00:00 |  |  |  |  |  |  | [NAME]
 |  | [NAME] | 210 | 08:00:00 |  | 10:00:00 | 1900-01-01 02:00:00 | 04:00:00 |  |  |  |  |  |  | [NAME]
 |  | Brasov Vest | 210 | 06:00:00 |  | 08:00:00 | 1900-01-01 02:00:00 | 04:00:00 |  |  |  |  |  |  | [NAME]
 |  | Brasov1 | 210 | 06:00:00 |  | 08:00:00 | 1900-01-01 02:00:00 | 04:00:00 |  |  |  |  |  |  | Brasov1
 |  | Brasov2 | 210 | 06:00:00 |  | 08:00:00 | 1900-01-01 02:00:00 | 04:00:00 |  |  |  |  |  |  | Brasov2
 |  | Pitesti Istoric | 137 | 09:00:00 |  | 11:00:00 | 1900-01-01 03:00:00 | 03:00:00 |  |  |  |  |  |  | Brasov Vest
 |  | Pitesti Gavana | 137 | 06:00:00 |  | 08:00:00 | 1900-01-01 03:00:00 | 03:00:00 |  |  |  |  |  |  | Pitesti Istoric
 |  | Ploiesti | 97 | 06:00:00 |  | 08:00:00 | 1900-01-01 04:00:00 | 02:00:00 |  |  |  |  |  |  | Pitesti Gavana
 |  | Liberty | 25 | 08:00:00 |  | 10:00:00 | 06:00:00 | 01:30:00 |  |  |  |  |  |  | Ploiesti
 |  | Liberty | 25 | 10:00:00 |  | 12:00:00 | 08:00:00 | 01:30:00 |  |  |  |  |  |  | Liberty
 |  | Satu Mare | 654 | 18:00:00 |  | 20:00:00 | 1900-01-01 02:30:00 | 15:30:00
 |  | Baia Mare | 587 | 18:00:00 |  | 20:00:00 | 1900-01-01 02:30:00 | 15:00:00
 |  | [NAME] | 581 | 18:00:00 |  | 20:00:00 | 1900-01-01 03:30:00 | 14:30:00
 |  | [NAME] | 581 | 18:00:00 |  | 20:00:00 | 1900-01-01 03:30:00 | 14:30:00
 |  | [NAME] | 581 | 18:00:00 |  | 20:00:00 | 1900-01-01 03:30:00 | 14:30:00
 |  | Oradea | 604 | 18:00:00 |  | 20:00:00 | 1900-01-01 03:00:00 | 15:00:00
 |  | Militari | 10 | 10:00:00 |  | 12:00:00 | 1900-01-01 04:00:00 | 02:00:00
 |  | Pallady | 30 | 10:00:00 |  | 12:00:00 | 17:00:00 | 01:30:00
 |  | Crangasi | 10 | 10:00:00 |  | 12:00:00 | 1900-01-01 04:00:00 | 02:00:00
 |  | Berceni | 20 | 10:00:00 |  | 12:00:00 | 1900-01-01 04:00:00 | 02:00:00
 |  | [NAME] | 10 | 10:00:00 |  | 12:00:00 | 1900-01-01 04:00:00 | 02:00:00
 |  | Cotroceni | 10 | 10:00:00 |  | 12:00:00 | 1900-01-01 04:00:00 | 02:00:00
 |  | Vitan | 25 | 10:00:00 |  | 12:00:00 | 1900-01-01 04:00:00 | 02:00:00
 |  | Titan | 30 | 10:00:00 |  | 12:00:00 | 1900-01-01 04:00:00 | 01:00:00
 |  | [NAME] | 466 | 18:00:00 |  | 20:00:00 | 1900-01-01 06:30:00 | 11:30:00
 |  | [NAME] | 466 | 18:00:00 |  | 20:00:00 | 1900-01-01 06:30:00 | 11:30:00
 |  | Targu Mures Istoric | 379 | 18:00:00 |  | 20:00:00 | 1900-01-01 09:30:00 | 08:30:00
 |  | Targu [NAME] | 379 | 18:00:00 |  | 20:00:00 | 1900-01-01 09:30:00 | 08:30:00
 |  | Deva | 412 | 18:00:00 |  | 20:00:00 | 1900-01-01 08:30:00 | 09:30:00
 |  | [NAME] | 296 | 16:00:00 |  | 18:00:00 | 1900-01-01 09:00:00 | 07:00:00
 |  | Iasi | 416 | 18:00:00 |  | 20:00:00 | 1900-01-01 09:00:00 | 09:00:00
 |  | [NAME] | 269 | 16:00:00 |  | 18:00:00 | 1900-01-01 11:00:00 | 05:00:00
 |  | [NAME] | 457 | 18:00:00 |  | 20:00:00 | 1900-01-01 08:30:00 | 09:30:00
 |  | Bacau | 304 | 16:00:00 |  | 18:00:00 | 1900-01-01 08:30:00 | 06:30:00
 |  | [NAME] | 291 | 16:00:00 |  | 18:00:00 | 1900-01-01 11:00:00 | 05:00:00
 |  | [NAME] | 291 | 16:00:00 |  | 18:00:00 | 1900-01-01 11:00:00 | 05:00:00
 |  | [NAME] | 254 | 16:00:00 |  | 18:00:00 | 1900-01-01 11:00:00 | 05:00:00
 |  | [NAME] | 254 | 16:00:00 |  | 18:00:00 | 1900-01-01 11:00:00 | 05:00:00
 |  | [NAME] | 210 | 14:00:00 |  | 16:00:00 | 1900-01-01 10:00:00 | 04:00:00
 |  | Brasov Vest | 210 | 16:00:00 |  | 18:00:00 | 1900-01-01 10:00:00 | 04:00:00
 |  | Brasov1 | 210 | 14:00:00 |  | 16:00:00 | 1900-01-01 10:00:00 | 04:00:00
 |  | Brasov2 | 210 | 14:00:00 |  | 16:00:00 | 1900-01-01 10:00:00 | 04:00:00
 |  | Pitesti Istoric | 137 | 12:00:00 |  | 14:00:00 | 1900-01-01 09:00:00 | 03:00:00
 |  | Pitesti Gavana | 137 | 12:00:00 |  | 14:00:00 | 1900-01-01 09:00:00 | 03:00:00
 |  | Ploiesti | 97 | 12:00:00 |  | 14:00:00 | 1900-01-01 10:00:00 | 02:00:00
 |  | Satu Mare | 654 | 20:00:00 |  | 22:00:00 | 1900-01-01 04:30:00 | 15:30:00
 |  | Baia Mare | 587 | 20:00:00 |  | 22:00:00 | 1900-01-01 04:30:00 | 15:00:00
 |  | [NAME] | 581 | 20:00:00 |  | 22:00:00 | 1900-01-01 05:30:00 | 14:30:00
 |  | [NAME] | 581 | 20:00:00 |  | 22:00:00 | 1900-01-01 05:30:00 | 14:30:00
 |  | [NAME] | 581 | 20:00:00 |  | 22:00:00 | 1900-01-01 05:30:00 | 14:30:00
 |  | Oradea | 604 | 20:00:00 |  | 22:00:00 | 1900-01-01 05:00:00 | 15:00:00
 |  | Militari | 10 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 02:00:00
 |  | Pallady | 30 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 01:30:00
 |  | Crangasi | 10 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 02:00:00
 |  | Berceni | 20 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 02:00:00
 |  | [NAME] | 10 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 02:00:00
 |  | Cotroceni | 10 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 02:00:00
 |  | Vitan | 25 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 02:00:00
 |  | Titan | 30 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 01:00:00
 |  | [NAME] | 466 | 20:00:00 |  | 22:00:00 | 1900-01-01 08:30:00 | 11:30:00
 |  | [NAME] | 466 | 20:00:00 |  | 22:00:00 | 1900-01-01 08:30:00 | 11:30:00
 |  | Targu Mures Istoric | 379 | 20:00:00 |  | 22:00:00 | 1900-01-01 11:30:00 | 08:30:00
 |  | Targu [NAME] | 379 | 20:00:00 |  | 22:00:00 | 1900-01-01 11:30:00 | 08:30:00
 |  | Deva | 412 | 20:00:00 |  | 22:00:00 | 1900-01-01 10:30:00 | 09:30:00
 |  | [NAME] | 296 | 20:00:00 |  | 22:00:00 | 1900-01-01 13:00:00 | 07:00:00
 |  | Iasi | 416 | 20:00:00 |  | 22:00:00 | 1900-01-01 11:00:00 | 09:00:00
 |  | [NAME] | 269 | 20:00:00 |  | 22:00:00 | 1900-01-01 15:00:00 | 05:00:00
 |  | [NAME] | 457 | 20:00:00 |  | 22:00:00 | 1900-01-01 10:30:00 | 09:30:00
 |  | Bacau | 304 | 20:00:00 |  | 22:00:00 | 1900-01-01 10:30:00 | 06:30:00
 |  | [NAME] | 291 | 20:00:00 |  | 22:00:00 | 1900-01-01 15:00:00 | 05:00:00
 |  | [NAME] | 291 | 20:00:00 |  | 22:00:00 | 1900-01-01 15:00:00 | 05:00:00
 |  | [NAME] | 254 | 20:00:00 |  | 22:00:00 | 1900-01-01 15:00:00 | 05:00:00
 |  | [NAME] | 254 | 20:00:00 |  | 22:00:00 | 1900-01-01 15:00:00 | 05:00:00
 |  | [NAME] | 210 | 20:00:00 |  | 22:00:00 | 1900-01-01 16:00:00 | 04:00:00
 |  | Brasov Vest | 210 | 20:00:00 |  | 22:00:00 | 1900-01-01 16:00:00 | 04:00:00
 |  | Pitesti Istoric | 137 | 20:00:00 |  | 22:00:00 | 1900-01-01 17:00:00 | 03:00:00
 |  | Pitesti Gavana | 137 | 20:00:00 |  | 22:00:00 | 1900-01-01 17:00:00 | 03:00:00
 |  | Ploiesti | 97 | 20:00:00 |  | 22:00:00 | 1900-01-01 18:00:00 | 02:00:00
 |  | Brasov1 | 210 | 20:00:00 |  | 22:00:00 | 1900-01-01 16:00:00 | 04:00:00
 |  | Brasov2 | 210 | 20:00:00 |  | 22:00:00 | 1900-01-01 16:00:00 | 04:00:00