Google Sheets – How to Create a Recursive Sum of Differences

formulasgoogle sheets

I am trying to implement a recursive sum of differences – that probably makes little sense. So basically I am keeping track of a vehicle mileages and on a separate tab (sheet) I wish to see the progress in mileage.

enter image description here

So, let's say, I wish to immediately find out how many miles I traveled on July 8th during day (so 151223-151080) and during the night (so 151308-150855151223), and so on. How could I implement that?

Best Answer

Lets assume the mileage data is in column C on sheet3.

Then in the cell where you want the answer to appear use the formula 

=max(Sheet3!C:C)-min(Sheet3!C:C)
Related Topic