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 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

1 Answer 1

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

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.