Macro to auto-populate date and time in text format

[excelpuzzled]

I need help scheduling my tweets in bulk.

I think there's a way to use Excel to automatically create a 5-day calendar. Maybe a macro?

The date format must be dd/mm/yyyy hh:mm and it must be in text format. If its June 9, 2012 at 6pm - the correct format is: 12/06/2012 18:00

I want to post 5 times a day: 09:05, 9:55, 10:45, 16:55 and 18:00.

Column A is where the date and time goes. Ideally, I'd enter in A1 the start date and then run a macro that would automatically populate the next 5 consecutive days with the specific times above (so 25 rows total in column A).

I have to save the file as a csv file, so the date and time format has to be in text or I'll get an upload error in Hootsuite.

Thanks in advance for any help or suggestions!

 

[Sal Paradise]

Excel 2003
	A
1	04/06/2012
2	04/06/2012 09:05
3	04/06/2012 09:55
4	04/06/2012 10:45
5	04/06/2012 16:55
6	04/06/2012 18:00
7	05/06/2012 09:05
8	05/06/2012 09:55
9	05/06/2012 10:45
10	05/06/2012 16:55
11	05/06/2012 18:00
12	06/06/2012 09:05
13	06/06/2012 09:55
14	06/06/2012 10:45
15	06/06/2012 16:55
16	06/06/2012 18:00
17	07/06/2012 09:05
18	07/06/2012 09:55
19	07/06/2012 10:45
20	07/06/2012 16:55
21	07/06/2012 18:00
22	08/06/2012 09:05
23	08/06/2012 09:55
24	08/06/2012 10:45
25	08/06/2012 16:55
26	08/06/2012 18:00
Sheet1

Cell Formulas
Range	Formula
A2	=TEXT($A$1+9/24+5/24/60,"dd/mm/yyyy hh:mm")
A3	=TEXT($A$1+9/24+55/24/60,"dd/mm/yyyy hh:mm")
A4	=TEXT($A$1+10/24+45/24/60,"dd/mm/yyyy hh:mm")
A5	=TEXT($A$1+16/24+55/24/60,"dd/mm/yyyy hh:mm")
A6	=TEXT($A$1+18/24,"dd/mm/yyyy hh:mm")
A7	=TEXT($A$1+1+9/24+5/24/60,"dd/mm/yyyy hh:mm")
A8	=TEXT($A$1+1+9/24+55/24/60,"dd/mm/yyyy hh:mm")
A9	=TEXT($A$1+1+10/24+45/24/60,"dd/mm/yyyy hh:mm")
A10	=TEXT($A$1+1+16/24+55/24/60,"dd/mm/yyyy hh:mm")
A11	=TEXT($A$1+1+18/24,"dd/mm/yyyy hh:mm")
A12	=TEXT($A$1+2+9/24+5/24/60,"dd/mm/yyyy hh:mm")
A13	=TEXT($A$1+2+9/24+55/24/60,"dd/mm/yyyy hh:mm")
A14	=TEXT($A$1+2+10/24+45/24/60,"dd/mm/yyyy hh:mm")
A15	=TEXT($A$1+2+16/24+55/24/60,"dd/mm/yyyy hh:mm")
A16	=TEXT($A$1+2+18/24,"dd/mm/yyyy hh:mm")
A17	=TEXT($A$1+3+9/24+5/24/60,"dd/mm/yyyy hh:mm")
A18	=TEXT($A$1+3+9/24+55/24/60,"dd/mm/yyyy hh:mm")
A19	=TEXT($A$1+3+10/24+45/24/60,"dd/mm/yyyy hh:mm")
A20	=TEXT($A$1+3+16/24+55/24/60,"dd/mm/yyyy hh:mm")
A21	=TEXT($A$1+3+18/24,"dd/mm/yyyy hh:mm")
A22	=TEXT($A$1+4+9/24+5/24/60,"dd/mm/yyyy hh:mm")
A23	=TEXT($A$1+4+9/24+55/24/60,"dd/mm/yyyy hh:mm")
A24	=TEXT($A$1+4+10/24+45/24/60,"dd/mm/yyyy hh:mm")
A25	=TEXT($A$1+4+16/24+55/24/60,"dd/mm/yyyy hh:mm")
A26	=TEXT($A$1+4+18/24,"dd/mm/yyyy hh:mm")