creating an array

[Richard]

I want to create a time array. For example, cell A1 is the starting time of
6:00 AM, and cell B1 which contains the ending time of 2 PM. From 6 am to 2
pm is exactly 8 hours. I want to create an array of 8 elements with the
starting value of 6:00 AM, and the last value in the array with the value of
2 pm. Of course, the array will start from cell C1 to J1 or 8 elements
cell. Is there a formula to do? or is it possible to do this in excel at
all? It would be similar to the one below.

A B C D E
F G --->>> J
6:00 AM 2:00 PM 6:00 AM
2:00 PM

 

[Richard]

ignore the drawing below, it is messed up.

 

[Sox]

I want to create a time array. For example, cell A1 is the starting time
of 6:00 AM, and cell B1 which contains the ending time of 2 PM. From 6 am
to 2 pm is exactly 8 hours. I want to create an array of 8 elements with
the starting value of 6:00 AM, and the last value in the array with the
value of 2 pm. Of course, the array will start from cell C1 to J1 or 8
elements cell. Is there a formula to do? or is it possible to do this in
excel at all? It would be similar to the one below.

A B C D E F
G --->>> J
6:00 AM 2:00 PM 6:00 AM 2:00 PM

Richard,

Try the TIME function, which takes the values (hours,minutes,seconds), for
example: = TIME(1,0,0) is one hour.

Then use the TIME function to add one hour to subsequent entries. For your
example:

A1 6:00 AM

B1 =A1 + TIME(1,0,0)

C1 =B1 + TIME(1,0,0)

....etc.

For a worksheet, simplfy the entries by just copying the formula in cell B1
across to add one hour to subsequent cells.

Regards,

Sox

 

[T. Valko]

Try this:

Enter this formula in C1 and copy across until you get blanks:

=IF(COUNT($A1:$B1)<2,"",IF($A1+(COLUMNS($A:A)-1)/24>$B1,"",$A1+(COLUMNS($A:A)-1)/24))

Format the cells as TIME

Biff