I would be very happy to get some advice on how to, in a range of cells, calculate differences between 2 values:
- 20:25:37,000
- 20:25:36,670
- 20:25:36,669
- 20:25,36,610
- 20:25,36,492
- 20:25,36,410
- 20:25,36,409
- 20:25,36,289
I would like to use a pattern here. First I want to calculate 1-4 and then 5-8, etc…
Is there any efficient way to perform this by some formula that you can use with autofill for instance?
Much grateful for tips