| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
creating an array
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating an array | New Users to Excel | |||
| creating an array | Excel Worksheet Functions | |||
| Creating and using an array | Excel Programming | |||
| creating an array on the fly | Excel Programming | |||
| Creating an array | Excel Programming | |||
Threaded Mode
