Calculation of the latest balance, subtract the old balance.

[numfon_naka]

Consumption km/L field, I need a formula like this.

The odometer will have several columns, that is, to record the data in and out of the factory. There will be a total of 6 refills.
Each day is filled about 3-5 times, but the calculations are calculated across columns.

e.g. ( odometer 1 - odometer 5 ) / liter of that column

[Ryan_Mortimer]

Are you recording all refills in one row or across multiple rows?

[numfon_naka]

YES

[numfon_naka]

For example, In odometer, day 1 minus day 2 equals the running distance field of line 2.
Next line, subtract date 2, date 3 to get the runnin value of line 3.

[Ryan_Mortimer]

And do you have one item you are tracking odo for? Or multiple?

i am just trying to wrap my head around exactly what part you are having trouble with.

if you had to do this in excel/sheets, would you be able to do this?

[numfon_naka]

In odometer = keys
Runing Distance = Calculate

will be divided into 3 columns

1. Date
   2.In odometer
   3.Runing Distance

the key is

1. 1/5/22 In odometer = 11245 Runing Distance =
2. 2/5/22 In odometer = 11546 Runing distance = 301
3. 3/5/22 In odometer = 12546 Runing distance = 1000
4. 4/5/22 In odometer = 12364 Runing Distance = 182
   (Running Distance is to subtract In odometer yesterday and In odometer today and keep deleting this way)