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?

  • share a copy of your sheet with example of desired output
    – user0
    Commented Jul 23, 2019 at 10:03
  • I have edited the question to show how you came to these numbers because that really was not immediately clear; please check if my assumptions are correct. Also, the fact that several people need to have access seems to irrelevant - I suggest you edit it out.
    – user55949
    Commented Jul 23, 2019 at 14:47

1 Answer 1


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

  • awesome! simple yet elegant ... but what if things are slightly more complex? Commented Jul 23, 2019 at 22:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.