Hi Everyone:

Please help! I got this to work yesterday by autofilling, but I can't remember how.

Basically I'm creating a posting chart for SM that needs to be in a certain forma for bulk uploads. One of these posts need to post every 3 hours, every day.

All in one cell, the format must read dd/mm/yyyy hh:mm. I need this pattern to continue.

Yesterday I could use the autofill somehow and just drag the series down - it autofilled the times and changed the dates. HELP!


25/06/2011 00:15
25/06/2011 03:15
25/06/2011 06:15
25/06/2011 09:15
25/06/2011 12:15
25/06/2011 15:15
25/06/2011 18:15
25/06/2011 21:15
26/06/2011 00:15
26/06/2011 03:15
26/06/2011 06:15
26/06/2011 09:15
26/06/2011 12:15
26/06/2011 15:15
26/06/2011 18:15
26/06/2011 21:15
27/06/2011 00:15
27/06/2011 03:15
27/06/2011 06:15
27/06/2011 09:15
27/06/2011 12:15
27/06/2011 15:15
27/06/2011 18:15
27/06/2011 21:15