Excel 2010 Date/Time Format Help

Hi All,

I wonder if anyone can help me please. Im hoping there is a quick way to auto populate some date/time values that i need.

Basically i need to get the date and time in the format of yyyy-mm-dd hh:mm as below:

2014-05-06 00:00
2014-05-06 01:00
2014-05-06 02:00
2014-05-06 03:00
2014-05-06 04:00
2014-05-06 05:00
2014-05-06 06:00
2014-05-06 07:00
2014-05-06 08:00
2014-05-06 09:00
2014-05-06 10:00
2014-05-06 11:00
2014-05-06 12:00
2014-05-06 13:00
2014-05-06 14:00
2014-05-06 15:00
2014-05-06 16:00
2014-05-06 17:00
2014-05-06 18:00
2014-05-06 19:00
2014-05-06 20:00
2014-05-06 21:00
2014-05-06 22:00
2014-05-06 23:00
2014-05-07 00:00
2014-05-07 01:00
2014-05-07 02:00
2014-05-07 03:00
2014-05-07 04:00
2014-05-07 05:00
2014-05-07 06:00
2014-05-07 07:00
2014-05-07 08:00
2014-05-07 09:00
2014-05-07 10:00
2014-05-07 11:00
2014-05-07 12:00
2014-05-07 13:00
2014-05-07 14:00
2014-05-07 15:00
2014-05-07 16:00
2014-05-07 17:00
2014-05-07 18:00
2014-05-07 19:00
2014-05-07 20:00
2014-05-07 21:00
2014-05-07 22:00
2014-05-07 23:00


I need to do this for 12 weeks going forward (i know there'll be a number of rows but it can't be helped!)
the format is set out like this for a specific reason so i can't change it.

I've done this in the past and i found a workaround way which involved a lot of painful manual editing so i really want to try and avoid this again this time so i wondered if anyone knew of a siomple way to get Excel to get this to work for me using a drag and drop or similar?

I've tried all variations of this but non seem to work properly, i seem to find that one way will mess up the time (i.e. the minutes will change by 1 rather than the hour) or the day doesnt change properly.

Thanks very much in advance, i realise i havent explained this very well so any further questions please give me a shout

Lee

akhileshgs thanks so much for taking the time to reply.
I've just attempted to use this now and not had much luck unfortunately.

I've put 2014-05-12 00:00 in cell A1 and tried the drag but the same thing just get displayed in every cell, it doesnt seem to change the hour and day as and when required.

Thanks again in advance,

Lee

hi Faraz.Ahmed - thank-you very much for that, all sorted and working now, much appreciated

Lee

Pleasure is all mine, Lee.

If you like it please click the * below.