I am trying to add 20 minutes to the time in the previous column on the same row, using Excel 2003. Is this possible? I'm having trouble figuring out how to get the current row. I can just use D to identify the column.

Things I've tried include [], and $. I'm not sure what I should be searching for, so terminology would also be useful.

In summary, basically: how to reference the current row in Excel, like D$current_row.


D       E
12:00   12:20
12:20   12:40
02:00   02:20
...     ...+20

In column E type in this formula:


Then click and drag the bottom right corner of the cell to copy the formula down column E to as far as you need.

I've used "D1" assuming your data is on the first row. If this is not the cause, just change the number to whatever row the data starts on.

E.g. assuming data starts on row 20:

  • I've tried this, and it seem to work! :D – Wolfpack'08 Mar 26 '13 at 9:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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