Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Example:

D       E
12:00   12:20
12:20   12:40
02:00   02:20
...     ...+20
share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

In column E type in this formula:

=D1+TIME(0,20,0)

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:

=D20+Time(0,20,0)
share|improve this answer
    
I've tried this, and it seem to work! :D –  Wolfpack'08 Mar 26 '13 at 9:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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