1 6 AM
2 7 AM
3 8 AM
4 9 AM
5 10 AM
6 11 AM
7 12 PM
8 1 PM
9 2 PM

If you want to start with 6 and end with 2, you need 9 elements.

--
Regards,
Tom Ogilvy

"Richard" wrote:

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