Autofilling Date AND Time in Column

[mcmitchell]

How do I autofill down a column with both the date and time? For instance, in Column A, Cell 1, I want to start with 01/01/2005 06:30 am, then in Cell 2, 01/01/2005 14:30 PM, and then in Cell 3 01/02/2005 06:30 am, etc.

[Rutgers_Excels]

If A1 contains 01/01/2005 06:30 AM, you can put the following equation in A2 and copy down...

=A1 + .5

Make sure your cells are formatted as follows...

mm/dd/yyyy hh:mm AM/PM

Hope that helps.