Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to automate time in Excel. I have two columns that show time advancing in minutes and seconds. I want to be able to automate so that if the time changes in one row, it will automatically correct in the times that follow that row. Any advice would be greatly appreciated.

share|improve this question
Just use relative references. Would you make your question a little bit more clear? You say you have columns but you want the rows to change. How does it look? – Raystafarian Mar 9 '12 at 18:18
7:57 AM 8:01 AM 8:01 AM 8:05 AM 8:03 AM 8:07 AM 8:05 AM 8:09 AM 8:09 AM 8:13 AM – Wendy Stevens Mar 9 '12 at 19:48
Sorry, the times are in two columns, I want them to automatically change if one time changes, for example, if the time 7:57 changes to 8:03, I want the next row below to reflect the change and become 8:06 from 8:01 automatically without me having to manually change all of the times that follow. – Wendy Stevens Mar 9 '12 at 19:50

Try doing this: in the first cell put your first time. In your example it is 7:57 in A1

In A2 put =A1+time(0,4,0) and drag that down column A. This will make every time at 4 minute intervals be dependent on A1. If you change A1 to 8:01, everything else changes. The formula is =time(hours,minutes,seconds) adjust accordingly

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .