Excel array help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

KGray32

Thread Starter
Joined
Jan 28, 2007
Messages
3
I'm in need of help. Here is the situation. I have a workbook in excel that has two columns of times in 24 hour format. These two columns of times need to be incremented by five minutes everyday. I was thinking that you could do that with an array. Would this be right? and if so can someone help me get started with the code. I have Excel 2003. Thanks.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Hello KGray, can we be quite clear on what you want the Macro to do please?
Do you want the Macro to increment the Times that are currently being stored in the 2 Columns?
Or do you want to add the Incremented Times on to the bottom of the 2 Columns?
 
Joined
Jul 25, 2004
Messages
5,458
Why can you not use a formula? Time is expressed as a fraction of a number, but it is numeric after all. 24 hours is one whole number, so 12 hours would be 0.5, so you can find five minutes that way.

HTH
 

KGray32

Thread Starter
Joined
Jan 28, 2007
Messages
3
Creating a formula is not the hard part I am just having trouble geting it to post in the columns. There are like 25 times in each column. I want everyother cell in each column to add 5 then update that cell. I tried a macro but that did not work. Thanks again.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
KGray, you do not state in which row you wish to start the Incrementing, the attached workbook has a macro that increments every other Row starting at Row 2.
It can be run by pressing Ctrl + a.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top