Excel 2010 Date/Time Format Help

In cell A1 type the date and time you want e.g. 5/6/2014 00:00 AM (Don't forget to write AM or PM in cell A1)
Then in cell A2 type "=A1+1/24" and drag cell A2 downward.

Then select the whole range of date and right click then format cells then Custom in Type text box type "yyyy-mm-mm hh:mm"
date format.PNG