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
$. 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 E 12:00 12:20 12:20 12:40 02:00 02:20 ... ...+20