Spreadsheet: 773153d1647654728-conditional-format-if-a-cell-in-column-c-is-less-than-the-former-row-of-d-odo-rollback-problem
Sheet: Sheet1

[NAME]
Date | Hours | Starting | Ending | Daily Total | Bonus | Period Hours | Period Miles | Vehicle |  | Daily Total | (Multiple Items)
2021-01-01 00:00:00 | 0 | 0 | 0 |  |  |  |  | PT Cruiser
2021-01-02 00:00:00 | 9 | 110473 | 110968 |  |  |  |  | PT Cruiser |  | Row Labels | Sum of Starting | Sum of Ending | Sum of Daily | Test
2021-01-03 00:00:00 | 0 | 0 | 0 |  |  |  |  | PT Cruiser |  | 2021-01-02 00:00:00 | 110473 | 110968 | 495
2021-01-04 00:00:00 | 6.25 | 111000 | 111346 |  |  |  |  | PT Cruiser |  | 2021-01-04 00:00:00 | 111000 | 111346 | 346
2021-01-05 00:00:00 | 6 | 111360 | 111369 |  |  |  |  | PT Cruiser |  | 2021-01-05 00:00:00 | 111360 | 111369 | 9
2021-01-06 00:00:00 | 6 | 111256 | 111495 |  |  |  |  | PT Cruiser |  | 2021-01-06 00:00:00 | 111256 | 111495 | 239
2021-01-07 00:00:00 | 7 | 111420 | 112020 |  |  |  |  | PT Cruiser |  | 2021-01-07 00:00:00 | 111420 | 112020 | 600
2021-01-08 00:00:00 | 7 | 112040 | 112095 |  |  |  |  | PT Cruiser |  | 2021-01-08 00:00:00 | 112040 | 112095 | 55
2021-01-09 00:00:00 | 4 | 112012 | 112172 |  |  |  |  | PT Cruiser |  | 2021-01-09 00:00:00 | 112012 | 112172 | 160
2021-01-10 00:00:00 | 0 | 0 | 0 |  |  |  |  | PT Cruiser |  | 2021-01-12 00:00:00 | 112000 | 112210 | 210
2021-01-11 00:00:00 | 6 | 0 | 0 |  |  |  |  | PT Cruiser |  | 2021-01-13 00:00:00 | 112400 | 112517 | 117
2021-01-12 00:00:00 | 6 | 112000 | 112210 |  |  |  |  | PT Cruiser |  | 2021-01-14 00:00:00 | 112539 | 112643 | 104
2021-01-13 00:00:00 | 6 | 112400 | 112517 |  |  |  |  | PT Cruiser |  | 2021-01-15 00:00:00 | 112666 | 112719 | 53
2021-01-14 00:00:00 | 7 | 112539 | 112643 |  |  |  |  | PT Cruiser |  | Grand Total | 1229166 | 1231554 | 2388
2021-01-15 00:00:00 | 7 | 112666 | 112719 |  |  |  |  | PT Cruiser
Date Time | Hours | [NAME] | End Odo | [NAME] | Vehicle | Problem?? |  | On the left - you need first to sort by Date Time from and second by [NAME].
2021-12-29 02:00:00 |  | 12148 | 12158 |  | Car1 |  |  | Then the formula in column G should work.
2021-12-30 14:00:00 |  | 12296 | 12298 |  | Car1
2021-12-31 16:00:00 |  | 12582 | 12610 |  | Car1 |  |  | I'd use a Pivot Table to get rid of the Zero days like the above, if I was doing this problem.
2021-12-31 18:00:00 |  | 12848 | 12883 |  | Car1
2021-12-31 22:00:00 |  | 13131 | 13170 |  | Car1
2021-12-31 22:00:00 |  | 13369 | 13380 |  | Car1
2022-01-06 04:00:00 |  | 13606 | 13651 |  | Car1
2022-01-10 00:00:00 |  | 13868 | 13870 |  | Car1
2022-01-11 18:00:00 |  | 14121 | 14168 |  | Car1
2022-01-12 12:00:00 |  | 14395 | 14415 |  | Car1
2022-01-14 08:00:00 |  | 14598 | 14622 |  | Car1
2022-01-14 14:00:00 |  | 14838 | 14839 |  | Car1
2022-01-15 08:00:00 |  | 15101 | 15101 |  | Car1
2022-01-15 16:00:00 |  | 15100 | 15370 |  | Car1
2022-01-18 16:00:00 |  | 15629 | 15673 |  | Car1
2022-01-19 14:00:00 |  | 15895 | 15929 |  | Car1
2022-01-24 10:00:00 |  | 15946 | 15986 |  | Car1
2022-01-26 06:00:00 |  | 16206 | 16232 |  | Car1
2022-01-26 12:00:00 |  | 16357 | 16395 |  | Car1
2022-01-29 20:00:00 |  | 16535 | 16537 |  | Car1
2022-01-30 10:00:00 |  | 16750 | 16780 |  | Car1
2022-01-30 14:00:00 |  | 16848 | 16873 |  | Car1
2022-02-01 18:00:00 |  | 16917 | 16949 |  | Car1
2022-02-03 14:00:00 |  | 17132 | 17157 |  | Car1
2022-02-09 04:00:00 |  | 17330 | 17353 |  | Car1
2022-02-11 14:00:00 |  | 17531 | 17530 |  | Car1
2022-02-12 00:00:00 |  | 17775 | 17772 |  | Car1
2022-02-13 12:00:00 |  | 17851 | 17869 |  | Car1
2022-02-21 14:00:00 |  | 18072 | 18108 |  | Car1
2022-02-26 00:00:00 |  | 18185 | 18213 |  | Car1
2022-02-27 16:00:00 |  | 18485 | 18514 |  | Car1
2022-03-03 20:00:00 |  | 18599 | 18629 |  | Car1
2022-03-06 06:00:00 |  | 18676 | 18712 |  | Car1
2022-03-09 14:00:00 |  | 18952 | 18984 |  | Car1
2022-03-13 20:00:00 |  | 19013 | 19022 |  | Car1
2022-03-15 06:00:00 |  | 19071 | 19096 |  | Car1
2022-03-21 02:00:00 |  | 19221 | 19251 |  | Car1
2022-03-25 20:00:00 |  | 19483 | 19488 |  | Car1
2022-03-27 04:00:00 |  | 19779 | 19824 |  | Car1
2022-03-27 20:00:00 |  | 19847 | 19847 |  | Car1
2022-03-31 08:00:00 |  | 20076 | 20074 |  | Car1
2022-03-31 16:00:00 |  | 20251 | 20289 |  | Car1
2021-12-24 14:00:00 |  | 20454 | 20471 |  | Car2
2021-12-26 20:00:00 |  | 20740 | 20765 |  | Car2
2021-12-28 20:00:00 |  | 20919 | 20962 |  | Car2
2021-12-29 00:00:00 |  | 21211 | 21226 |  | Car2
2022-01-01 00:00:00 |  | 21373 | 21370 |  | Car2
2022-01-01 18:00:00 |  | 21592 | 21633 |  | Car2
2022-01-03 20:00:00 |  | 21852 | 21893 |  | Car2
2022-01-03 22:00:00 |  | 21907 | 21927 |  | Car2
2022-01-05 18:00:00 |  | 22069 | 22116 |  | Car2
2022-01-08 06:00:00 |  | 22249 | 22276 |  | Car2
2022-01-08 12:00:00 |  | 22546 | 22569 |  | Car2
2022-01-10 18:00:00 |  | 22752 | 22765 |  | Car2
2022-01-11 22:00:00 |  | 22988 | 22994 |  | Car2
2022-01-14 20:00:00 |  | 23099 | 23146 |  | Car2
2022-01-15 18:00:00 |  | 23168 | 23201 |  | Car2
2022-01-17 08:00:00 |  | 23445 | 23472 |  | Car2
2022-01-18 10:00:00 |  | 23524 | 23554 |  | Car2
2022-01-18 14:00:00 |  | 23769 | 23799 |  | Car2
2022-01-21 04:00:00 |  | 24024 | 24037 |  | Car2
2022-01-21 22:00:00 |  | 24237 | 24285 |  | Car2
2022-01-24 14:00:00 |  | 24376 | 24404 |  | Car2
2022-01-27 14:00:00 |  | 24600 | 24647 |  | Car2
2022-01-27 18:00:00 |  | 24784 | 24819 |  | Car2
2022-01-28 10:00:00 |  | 24983 | 24997 |  | Car2
2022-01-28 16:00:00 |  | 25153 | 25153 |  | Car2
2022-01-29 00:00:00 |  | 25244 | 25269 |  | Car2
2022-01-29 10:00:00 |  | 25441 | 25488 |  | Car2
2022-01-30 00:00:00 |  | 25557 | 25589 |  | Car2
2022-01-30 10:00:00 |  | 25669 | 25714 |  | Car2
2022-01-31 00:00:00 |  | 25861 | 25863 |  | Car2
2022-01-31 06:00:00 |  | 26084 | 26099 |  | Car2
2022-01-31 16:00:00 |  | 26258 | 26267 |  | Car2
2022-02-03 14:00:00 |  | 26468 | 26477 |  | Car2
2022-02-06 06:00:00 |  | 26701 | 26705 |  | Car2
2022-02-08 02:00:00 |  | 27000 | 27012 |  | Car2
2022-02-10 10:00:00 |  | 27299 | 27325 |  | Car2
2022-02-14 22:00:00 |  | 27310 | 27564 |  | Car2
2022-02-15 18:00:00 |  | 27825 | 27829 |  | Car2
2022-02-22 14:00:00 |  | 28113 | 28146 |  | Car2
2022-02-23 00:00:00 |  | 28238 | 28252 |  | Car2
2022-02-25 04:00:00 |  | 28398 | 28441 |  | Car2
2022-02-26 18:00:00 |  | 28560 | 28604 |  | Car2
2022-03-05 06:00:00 |  | 28657 | 28658 |  | Car2
2022-03-06 22:00:00 |  | 28934 | 28951 |  | Car2
2022-03-07 18:00:00 |  | 29000 | 29008 |  | Car2
2022-03-09 06:00:00 |  | 29126 | 29138 |  | Car2
2022-03-18 12:00:00 |  | 29416 | 29417 |  | Car2
2022-03-18 22:00:00 |  | 29712 | 29761 |  | Car2
2022-03-19 10:00:00 |  | 29926 | 29933 |  | Car2
2022-03-22 22:00:00 |  | 30019 | 30060 |  | Car2
2022-03-27 12:00:00 |  | 30257 | 30277 |  | Car2
2022-04-02 08:00:00 |  | 30316 | 30334 |  | Car2
2022-04-02 20:00:00 |  | 30371 | 30371 |  | Car2
2022-04-09 10:00:00 |  | 30441 | 30447 |  | Car2
2021-12-29 02:00:00 |  | 30660 | 30688 |  | Car3
2021-12-29 08:00:00 |  | 30744 | 30752 |  | Car3
2021-12-30 00:00:00 |  | 30977 | 31004 |  | Car3
2021-12-30 12:00:00 |  | 31145 | 31180 |  | Car3
2021-12-31 06:00:00 |  | 31295 | 31337 |  | Car3
2022-01-03 02:00:00 |  | 31452 | 31488 |  | Car3
2022-01-06 00:00:00 |  | 31524 | 31546 |  | Car3
2022-01-06 06:00:00 |  | 31609 | 31636 |  | Car3
2022-01-06 12:00:00 |  | 31854 | 31891 |  | Car3
2022-01-07 08:00:00 |  | 32097 | 32119 |  | Car3
2022-01-09 14:00:00 |  | 32280 | 32301 |  | Car3
2022-01-09 22:00:00 |  | 32384 | 32430 |  | Car3
2022-01-11 12:00:00 |  | 32485 | 32506 |  | Car3
2022-01-11 18:00:00 |  | 32733 | 32740 |  | Car3
2022-01-12 14:00:00 |  | 32980 | 33007 |  | Car3
2022-01-13 14:00:00 |  | 33278 | 33301 |  | Car3
2022-01-15 06:00:00 |  | 33384 | 33406 |  | Car3
2022-01-16 14:00:00 |  | 33527 | 33547 |  | Car3
2022-01-16 22:00:00 |  | 33809 | 33852 |  | Car3
2022-01-29 00:00:00 |  | 34056 | 34067 |  | Car3
2022-01-29 20:00:00 |  | 34230 | 34240 |  | Car3
2022-02-04 08:00:00 |  | 34388 | 34414 |  | Car3
2022-02-05 16:00:00 |  | 34502 | 34513 |  | Car3
2022-02-09 18:00:00 |  | 34609 | 34649 |  | Car3
2022-02-12 18:00:00 |  | 34802 | 34828 |  | Car3
2022-02-12 20:00:00 |  | 34986 | 35026 |  | Car3
2022-02-16 20:00:00 |  | 35153 | 35163 |  | Car3
2022-02-18 14:00:00 |  | 35235 | 35400 |  | Car3
2022-02-20 12:00:00 |  | 35385 | 35388 |  | Car3
2022-02-21 04:00:00 |  | 35678 | 35700 |  | Car3
2022-02-23 04:00:00 |  | 35786 | 35815 |  | Car3
2022-02-24 22:00:00 |  | 35952 | 35986 |  | Car3
2022-02-26 10:00:00 |  | 36163 | 36207 |  | Car3
2022-02-27 14:00:00 |  | 36228 | 36253 |  | Car3
2022-02-28 22:00:00 |  | 36508 | 36540 |  | Car3
2022-03-01 16:00:00 |  | 36650 | 36688 |  | Car3
2022-03-02 04:00:00 |  | 36773 | 36795 |  | Car3
2022-03-04 22:00:00 |  | 36905 | 36938 |  | Car3
2022-03-05 04:00:00 |  | 37038 | 37053 |  | Car3
2022-03-08 08:00:00 |  | 37092 | 37089 |  | Car3
2022-03-11 08:00:00 |  | 37160 | 37186 |  | Car3
2022-03-11 20:00:00 |  | 37313 | 37319 |  | Car3
2022-03-13 16:00:00 |  | 37393 | 37411 |  | Car3
2022-03-14 12:00:00 |  | 37530 | 37543 |  | Car3
2022-03-18 00:00:00 |  | 37783 | 37823 |  | Car3
2022-03-19 18:00:00 |  | 37989 | 38036 |  | Car3
2022-03-22 22:00:00 |  | 38090 | 38106 |  | Car3
2022-03-23 12:00:00 |  | 38390 | 38389 |  | Car3
2022-03-26 16:00:00 |  | 38643 | 38673 |  | Car3
2022-03-27 22:00:00 |  | 38907 | 38945 |  | Car3
2022-03-28 10:00:00 |  | 39114 | 39124 |  | Car3
2022-03-29 22:00:00 |  | 39191 | 39203 |  | Car3
2022-04-03 08:00:00 |  | 39281 | 39312 |  | Car3
2022-04-07 04:00:00 |  | 39433 | 39463 |  | Car3
2021-12-13 06:00:00 |  | 39583 | 39626 |  | Car4
2021-12-19 06:00:00 |  | 39747 | 39781 |  | Car4
2021-12-23 00:00:00 |  | 39820 | 39843 |  | Car4
2021-12-29 06:00:00 |  | 40075 | 40106 |  | Car4
2021-12-31 02:00:00 |  | 40225 | 40246 |  | Car4
2022-01-01 08:00:00 |  | 40379 | 40384 |  | Car4
2022-01-01 20:00:00 |  | 40649 | 40692 |  | Car4
2022-01-06 10:00:00 |  | 40866 | 40889 |  | Car4
2022-01-07 16:00:00 |  | 40951 | 40988 |  | Car4
2022-01-08 00:00:00 |  | 41176 | 41221 |  | Car4
2022-01-08 12:00:00 |  | 41330 | 41332 |  | Car4
2022-01-12 14:00:00 |  | 41491 | 41536 |  | Car4
2022-01-14 22:00:00 |  | 41700 | 41715 |  | Car4
2022-01-18 06:00:00 |  | 41792 | 41797 |  | Car4
2022-01-18 12:00:00 |  | 41977 | 41986 |  | Car4
2022-01-20 18:00:00 |  | 42144 | 42191 |  | Car4
2022-01-20 22:00:00 |  | 42257 | 42256 |  | Car4
2022-01-22 12:00:00 |  | 42377 | 42382 |  | Car4
2022-01-22 14:00:00 |  | 42551 | 42551 |  | Car4
2022-01-22 14:00:00 |  | 42677 | 42718 |  | Car4
2022-01-23 22:00:00 |  | 42909 | 42918 |  | Car4
2022-01-25 06:00:00 |  | 43000 | 43046 |  | Car4
2022-01-26 06:00:00 |  | 43133 | 43154 |  | Car4
2022-01-26 16:00:00 |  | 43432 | 43450 |  | Car4
2022-01-26 20:00:00 |  | 43573 | 43597 |  | Car4
2022-01-28 06:00:00 |  | 43752 | 43789 |  | Car4
2022-01-31 18:00:00 |  | 43854 | 43897 |  | Car4
2022-02-01 02:00:00 |  | 44055 | 44089 |  | Car4
2022-02-01 10:00:00 |  | 44253 | 44253 |  | Car4
2022-02-01 12:00:00 |  | 44372 | 44418 |  | Car4
2022-02-03 16:00:00 |  | 44479 | 44484 |  | Car4
2022-02-04 22:00:00 |  | 44719 | 44733 |  | Car4
2022-02-06 12:00:00 |  | 44990 | 44988 |  | Car4
2022-02-07 20:00:00 |  | 45228 | 45255 |  | Car4
2022-02-08 00:00:00 |  | 45413 | 45444 |  | Car4
2022-02-12 18:00:00 |  | 45482 | 45511 |  | Car4
2022-02-19 08:00:00 |  | 45618 | 45657 |  | Car4
2022-02-22 16:00:00 |  | 45854 | 45897 |  | Car4
2022-02-23 12:00:00 |  | 46000 | 46029 |  | Car4
2022-03-02 14:00:00 |  | 46069 | 46109 |  | Car4
2022-03-03 14:00:00 |  | 46237 | 46276 |  | Car4
2022-03-04 12:00:00 |  | 46368 | 46402 |  | Car4
2022-03-18 16:00:00 |  | 46446 | 46466 |  | Car4
2022-03-18 20:00:00 |  | 46643 | 46689 |  | Car4
2022-03-21 08:00:00 |  | 46708 | 46715 |  | Car4
2022-03-22 22:00:00 |  | 46867 | 46905 |  | Car4
2022-03-25 12:00:00 |  | 47099 | 47119 |  | Car4
2022-03-25 20:00:00 |  | 47336 | 47371 |  | Car4
2022-03-28 00:00:00 |  | 47420 | 47454 |  | Car4
2022-04-01 10:00:00 |  | 47519 | 47537 |  | Car4
2021-12-16 10:00:00 |  | 47783 | 47809 |  | [NAME]
2021-12-20 00:00:00 |  | 48036 | 48035 |  | [NAME]
2021-12-20 20:00:00 |  | 48250 | 48258 |  | [NAME]
2021-12-27 02:00:00 |  | 48342 | 48349 |  | [NAME]
2021-12-29 02:00:00 |  | 48632 | 48629 |  | [NAME]
2021-12-30 18:00:00 |  | 48691 | 48709 |  | [NAME]
2021-12-31 14:00:00 |  | 48843 | 48893 |  | [NAME]
2022-01-04 16:00:00 |  | 49010 | 49009 |  | [NAME]
2022-01-05 12:00:00 |  | 49282 | 49283 |  | [NAME]
2022-01-05 22:00:00 |  | 49558 | 49602 |  | [NAME]
2022-01-10 06:00:00 |  | 49679 | 49726 |  | [NAME]
2022-01-12 04:00:00 |  | 49979 | 49983 |  | [NAME]
2022-01-13 00:00:00 |  | 50125 | 50146 |  | [NAME]
2022-01-17 00:00:00 |  | 50393 | 50398 |  | [NAME]
2022-01-17 02:00:00 |  | 50473 | 50495 |  | [NAME]
2022-01-20 10:00:00 |  | 50737 | 50747 |  | [NAME]
2022-01-22 02:00:00 |  | 50944 | 50969 |  | [NAME]
2022-01-25 04:00:00 |  | 51145 | 51178 |  | [NAME]
2022-01-26 22:00:00 |  | 51292 | 51337 |  | [NAME]
2022-01-27 10:00:00 |  | 51458 | 51496 |  | [NAME]
2022-01-27 22:00:00 |  | 51663 | 51692 |  | [NAME]
2022-01-28 02:00:00 |  | 51815 | 51861 |  | [NAME]
2022-01-29 14:00:00 |  | 51955 | 51974 |  | [NAME]
2022-01-31 02:00:00 |  | 52096 | 52109 |  | [NAME]
2022-01-31 20:00:00 |  | 52153 | 52175 |  | [NAME]
2022-02-01 16:00:00 |  | 52428 | 52432 |  | [NAME]
2022-02-02 00:00:00 |  | 52569 | 52619 |  | [NAME]
2022-02-05 06:00:00 |  | 52623 | 52652 |  | [NAME]
2022-02-10 16:00:00 |  | 52872 | 52921 |  | [NAME]
2022-02-11 04:00:00 |  | 52976 | 53016 |  | [NAME]
2022-02-11 08:00:00 |  | 53239 | 53273 |  | [NAME]
2022-02-12 06:00:00 |  | 53483 | 53485 |  | [NAME]
2022-02-13 06:00:00 |  | 53763 | 53792 |  | [NAME]
2022-02-16 12:00:00 |  | 54041 | 54075 |  | [NAME]
2022-02-17 10:00:00 |  | 54249 | 54254 |  | [NAME]
2022-02-17 14:00:00 |  | 54458 | 54487 |  | [NAME]
2022-02-17 14:00:00 |  | 54600 | 54643 |  | [NAME]
2022-02-19 00:00:00 |  | 54809 | 54813 |  | [NAME]
2022-02-20 18:00:00 |  | 55009 | 55059 |  | [NAME]
2022-02-22 02:00:00 |  | 55222 | 55234 |  | [NAME]
2022-02-22 08:00:00 |  | 55485 | 55522 |  | [NAME]
2022-02-24 06:00:00 |  | 55623 | 55662 |  | [NAME]
2022-02-26 06:00:00 |  | 55807 | 55832 |  | [NAME]
2022-02-28 12:00:00 |  | 55989 | 56012 |  | [NAME]
2022-02-28 14:00:00 |  | 56241 | 56267 |  | [NAME]
2022-03-05 22:00:00 |  | 56477 | 56487 |  | [NAME]
2022-03-06 12:00:00 |  | 56751 | 56774 |  | [NAME]
2022-03-06 12:00:00 |  | 56976 | 56983 |  | [NAME]
2022-03-07 20:00:00 |  | 57122 | 57162 |  | [NAME]
2022-03-08 06:00:00 |  | 57256 | 57262 |  | [NAME]
2022-03-11 08:00:00 |  | 57473 | 57488 |  | [NAME]
2022-03-11 08:00:00 |  | 57699 | 57749 |  | [NAME]
2022-03-11 20:00:00 |  | 57833 | 57880 |  | [NAME]
2022-03-19 06:00:00 |  | 58082 | 58103 |  | [NAME]
2022-03-21 10:00:00 |  | 58148 | 58153 |  | [NAME]
2022-03-22 12:00:00 |  | 58357 | 58376 |  | [NAME]
2022-03-26 20:00:00 |  | 58522 | 58550 |  | [NAME]
2022-03-27 04:00:00 |  | 58616 | 58639 |  | [NAME]
2022-03-28 20:00:00 |  | 58777 | 58789 |  | [NAME]
2022-03-31 04:00:00 |  | 59016 | 59020 |  | [NAME]