Hi, I'm a first timer out of dark Africa
I'm trying to track fuel usage for a small fleet.
My issue is how to calculate the distance traveled between dates on a specific vehicle.
Any help would be much appreciated.
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
I'm trying to track fuel usage for a small fleet.
My issue is how to calculate the distance traveled between dates on a specific vehicle.
Any help would be much appreciated.
Vehicle ID | Date | ODO Meter | Distance km | Liters - Depot | Result |
Truck1 | 2018/10/01 | 14500 | 171 | 0,00 | |
Truck3 | 2018/10/01 | 32410 | 164 | 0,00 | |
Truck2 | 2018/10/02 | 20350 | 333 | 0,00 | |
Truck2 | 2018/10/13 | 20740 | 160 | 0,00 | |
Truck1 | 2018/10/15 | 14800 | 143 | 0,00 | |
Truck3 | 2018/10/19 | 32890 | 178 | 0,00 | |
Truck3 | 2018/10/19 | 33450 | 243 | 0,00 | |
Truck1 | 2018/10/21 | 15550 | 385 | 0,00 | |
Truck2 | 2018/10/22 | 21570 | 370 | 0,00 | |
Truck1 | 2018/10/25 | 15940 | 176 | 0,00 | |
Truck3 | 2018/10/26 | 33980 | 226 | 0,00 | |
Truck2 | 2018/10/27 | 21980 | 185 | 0,00 |
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>