creating an array
ignore the drawing below, it is messed up.
"Richard" wrote in message
. ..
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
|