How to create lsit of datetime?

[nhalina81]

Hi,

I really not good in macro. Need anyone to help me on this.
How to make macro to create a list of datetime?
I have StartDate in A2 cell and EndDate in B2 cell.
The list of datetime will start from the StartDate and end with EndDate.


Example:
StartDate : 2-Feb-2013
EndDate : 5-Feb-2003

Result should be like this:
2-Feb-2003 12:00:00 AM
2-Feb-2003 1:00:00 AM
2-Feb-2003 2:00:00 AM
.
.
2-Feb-2003 11:00:00 PM
3-Feb-2003 12:00:00 AM
3-Feb-2003 1:00:00 AM
3-Feb-2003 2:00:00 AM
.
.
3-Feb-2003 11:00:00 PM
4-Feb-2003 12:00:00 AM
4-Feb-2003 1:00:00 AM
4-Feb-2003 2:00:00 AM
.
.
4-Feb-2003 11:00:00 PM
5-Feb-2003 12:00:00 AM
5-Feb-2003 1:00:00 AM
5-Feb-2003 2:00:00 AM
.
.
5-Feb-2003 11:00:00 PM


Please help me...

Thank you

[dilipandey]

Hi nhalina,

welcome to the forum.

Do you need data list as 11 PM, 12 AM, 1 AM , 2 AM OR,
do you need every hour difference in data list starting from startdate till end date ?


Also, try looking at Home -> Fill option. thanks.

Regards,
DILIPandey
<click on below * if this helps>

[kvsrinivasamurthy]

Pl see the attached file with formula.

[nhalina81]

Hi DILIPandey,

The StartDate in A2 cell and EndDate in B2 cell format is dd/mm/yyyy.
I need result to show a list of one hour interval starting StartDate 12:00:00 AM until EndDate 11:00:00 PM.
How to make macro to create a list?


Hi kvsrinivasamurthy,

Where can I find the formula?



Thank you

[dilipandey]

Hi nhalina,

Used below macro in the attached file:-

Please Login or Register  to view this content.

see attached:- list of date time with 1 hour gap.xlsm


Regards,
DILIPandey
<click on below * if this helps>

[nhalina81]

Thank a lot DILIPandey!!!! it works!!!!!

[dilipandey]

you are welcome nhalina.... cheers


suggest you to mark this thread as [SOLVED].. Thanks.


Regards,
DILIPandey
<click on below * if this helps>