Date and Time for one month for 24 hours in one column

suyah

New Member
Joined
Aug 12, 2014
Messages
13
I have difficulties in date and time format. Since I always need to change the day/month/year. Usually I just did it manually, however after I found this amazing macro things, I hope I can do it using macro which can save me a lot of time.

Here the situation is:

I have 16 years (1996-2011) data to do this which in each years have 12 month, in one month which have different days (28/29/30/31) and each day 24 hours. I want to write it in one column for one month.

Example of result:

date
01/04/1996 01:00:00
01/04/1996 02:00:00
01/04/1996 03:00:00
01/04/1996 04:00:00
01/04/1996 05:00:00
01/04/1996 06:00:00
01/04/1996 07:00:00
01/04/1996 08:00:00
01/04/1996 09:00:00
01/04/1996 10:00:00
01/04/1996 11:00:00
01/04/1996 12:00:00
01/04/1996 13:00:00
01/04/1996 14:00:00
01/04/1996 15:00:00
01/04/1996 16:00:00
01/04/1996 17:00:00
01/04/1996 18:00:00
01/04/1996 19:00:00
01/04/1996 20:00:00
01/04/1996 21:00:00
01/04/1996 22:00:00
01/04/1996 23:00:00
01/04/1996 00:00:00
02/04/1996 01:00:00
02/04/1996 02:00:00
02/04/1996 03:00:00
02/04/1996 04:00:00
02/04/1996 05:00:00
02/04/1996 06:00:00
02/04/1996 07:00:00
02/04/1996 08:00:00
02/04/1996 09:00:00
02/04/1996 10:00:00
02/04/1996 11:00:00
02/04/1996 12:00:00
02/04/1996 13:00:00
02/04/1996 14:00:00
02/04/1996 15:00:00
02/04/1996 16:00:00
02/04/1996 17:00:00
02/04/1996 18:00:00
02/04/1996 19:00:00
02/04/1996 20:00:00
02/04/1996 21:00:00
02/04/1996 22:00:00
02/04/1996 23:00:00
02/04/1996 00:00:00
03/04/1996 01:00:00
03/04/1996 02:00:00
03/04/1996 03:00:00
03/04/1996 04:00:00
03/04/1996 05:00:00
03/04/1996 06:00:00
03/04/1996 07:00:00
03/04/1996 08:00:00
03/04/1996 09:00:00
03/04/1996 10:00:00
03/04/1996 11:00:00
03/04/1996 12:00:00
03/04/1996 13:00:00
03/04/1996 14:00:00
03/04/1996 15:00:00
03/04/1996 16:00:00
03/04/1996 17:00:00
03/04/1996 18:00:00
03/04/1996 19:00:00
03/04/1996 20:00:00
03/04/1996 21:00:00
03/04/1996 22:00:00
03/04/1996 23:00:00
03/04/1996 00:00:00
04/04/1996 01:00:00
04/04/1996 02:00:00
04/04/1996 03:00:00
04/04/1996 04:00:00
04/04/1996 05:00:00
04/04/1996 06:00:00
04/04/1996 07:00:00
04/04/1996 08:00:00
04/04/1996 09:00:00
04/04/1996 10:00:00
04/04/1996 11:00:00
04/04/1996 12:00:00
04/04/1996 13:00:00
04/04/1996 14:00:00
04/04/1996 15:00:00
04/04/1996 16:00:00
04/04/1996 17:00:00
04/04/1996 18:00:00
04/04/1996 19:00:00
04/04/1996 20:00:00
04/04/1996 21:00:00
04/04/1996 22:00:00
04/04/1996 23:00:00
04/04/1996 00:00:00
05/04/1996 01:00:00
05/04/1996 02:00:00
05/04/1996 03:00:00
05/04/1996 04:00:00
05/04/1996 05:00:00
05/04/1996 06:00:00
05/04/1996 07:00:00
05/04/1996 08:00:00
05/04/1996 09:00:00
05/04/1996 10:00:00
05/04/1996 11:00:00
05/04/1996 12:00:00
05/04/1996 13:00:00
05/04/1996 14:00:00
05/04/1996 15:00:00
05/04/1996 16:00:00
05/04/1996 17:00:00
05/04/1996 18:00:00
05/04/1996 19:00:00
05/04/1996 20:00:00
05/04/1996 21:00:00
05/04/1996 22:00:00
05/04/1996 23:00:00
05/04/1996 00:00:00
06/04/1996 01:00:00
06/04/1996 02:00:00
06/04/1996 03:00:00
06/04/1996 04:00:00
06/04/1996 05:00:00
06/04/1996 06:00:00
06/04/1996 07:00:00
06/04/1996 08:00:00
06/04/1996 09:00:00
06/04/1996 10:00:00
06/04/1996 11:00:00
06/04/1996 12:00:00
06/04/1996 13:00:00
06/04/1996 14:00:00
06/04/1996 15:00:00
06/04/1996 16:00:00
06/04/1996 17:00:00
06/04/1996 18:00:00
06/04/1996 19:00:00
06/04/1996 20:00:00
06/04/1996 21:00:00
06/04/1996 22:00:00
06/04/1996 23:00:00
06/04/1996 00:00:00
07/04/1996 01:00:00
07/04/1996 02:00:00
07/04/1996 03:00:00
07/04/1996 04:00:00
07/04/1996 05:00:00
07/04/1996 06:00:00
07/04/1996 07:00:00
07/04/1996 08:00:00
07/04/1996 09:00:00
07/04/1996 10:00:00
07/04/1996 11:00:00
07/04/1996 12:00:00
07/04/1996 13:00:00
07/04/1996 14:00:00
07/04/1996 15:00:00
07/04/1996 16:00:00
07/04/1996 17:00:00
07/04/1996 18:00:00
07/04/1996 19:00:00
07/04/1996 20:00:00
07/04/1996 21:00:00
07/04/1996 22:00:00
07/04/1996 23:00:00
07/04/1996 00:00:00
08/04/1996 01:00:00
08/04/1996 02:00:00
08/04/1996 03:00:00
08/04/1996 04:00:00
08/04/1996 05:00:00
08/04/1996 06:00:00
08/04/1996 07:00:00
08/04/1996 08:00:00
08/04/1996 09:00:00
08/04/1996 10:00:00
08/04/1996 11:00:00
08/04/1996 12:00:00
08/04/1996 13:00:00
08/04/1996 14:00:00
08/04/1996 15:00:00
08/04/1996 16:00:00
08/04/1996 17:00:00
08/04/1996 18:00:00
08/04/1996 19:00:00
08/04/1996 20:00:00
08/04/1996 21:00:00
08/04/1996 22:00:00
08/04/1996 23:00:00
08/04/1996 00:00:00
09/04/1996 01:00:00
09/04/1996 02:00:00
09/04/1996 03:00:00
09/04/1996 04:00:00
09/04/1996 05:00:00
09/04/1996 06:00:00
09/04/1996 07:00:00
09/04/1996 08:00:00
09/04/1996 09:00:00
09/04/1996 10:00:00
09/04/1996 11:00:00
09/04/1996 12:00:00
09/04/1996 13:00:00
09/04/1996 14:00:00
09/04/1996 15:00:00
09/04/1996 16:00:00
09/04/1996 17:00:00
09/04/1996 18:00:00
09/04/1996 19:00:00
09/04/1996 20:00:00
09/04/1996 21:00:00
09/04/1996 22:00:00
09/04/1996 23:00:00
09/04/1996 00:00:00
10/04/1996 01:00:00
10/04/1996 02:00:00
10/04/1996 03:00:00
10/04/1996 04:00:00
10/04/1996 05:00:00
10/04/1996 06:00:00
10/04/1996 07:00:00
10/04/1996 08:00:00
10/04/1996 09:00:00
10/04/1996 10:00:00
10/04/1996 11:00:00
10/04/1996 12:00:00
10/04/1996 13:00:00
10/04/1996 14:00:00
10/04/1996 15:00:00
10/04/1996 16:00:00
10/04/1996 17:00:00
10/04/1996 18:00:00
10/04/1996 19:00:00
10/04/1996 20:00:00
10/04/1996 21:00:00
10/04/1996 22:00:00
10/04/1996 23:00:00
10/04/1996 00:00:00
11/04/1996 01:00:00
11/04/1996 02:00:00
11/04/1996 03:00:00
11/04/1996 04:00:00
11/04/1996 05:00:00
11/04/1996 06:00:00
11/04/1996 07:00:00
11/04/1996 08:00:00
11/04/1996 09:00:00
11/04/1996 10:00:00
11/04/1996 11:00:00
11/04/1996 12:00:00
11/04/1996 13:00:00
11/04/1996 14:00:00
11/04/1996 15:00:00
11/04/1996 16:00:00
11/04/1996 17:00:00
11/04/1996 18:00:00
11/04/1996 19:00:00
11/04/1996 20:00:00
11/04/1996 21:00:00
11/04/1996 22:00:00
11/04/1996 23:00:00
11/04/1996 00:00:00
12/04/1996 01:00:00
12/04/1996 02:00:00
12/04/1996 03:00:00
12/04/1996 04:00:00
12/04/1996 05:00:00
12/04/1996 06:00:00
12/04/1996 07:00:00
12/04/1996 08:00:00
12/04/1996 09:00:00
12/04/1996 10:00:00
12/04/1996 11:00:00
12/04/1996 12:00:00
12/04/1996 13:00:00
12/04/1996 14:00:00
12/04/1996 15:00:00
12/04/1996 16:00:00
12/04/1996 17:00:00
12/04/1996 18:00:00
12/04/1996 19:00:00
12/04/1996 20:00:00
12/04/1996 21:00:00
12/04/1996 22:00:00
12/04/1996 23:00:00
12/04/1996 00:00:00
13/04/1996 01:00:00
13/04/1996 02:00:00
13/04/1996 03:00:00
13/04/1996 04:00:00
13/04/1996 05:00:00
13/04/1996 06:00:00
13/04/1996 07:00:00
13/04/1996 08:00:00
13/04/1996 09:00:00
13/04/1996 10:00:00
13/04/1996 11:00:00
13/04/1996 12:00:00
13/04/1996 13:00:00
13/04/1996 14:00:00
13/04/1996 15:00:00
13/04/1996 16:00:00
13/04/1996 17:00:00
13/04/1996 18:00:00
13/04/1996 19:00:00
13/04/1996 20:00:00
13/04/1996 21:00:00
13/04/1996 22:00:00
13/04/1996 23:00:00
13/04/1996 00:00:00
14/04/1996 01:00:00
14/04/1996 02:00:00
14/04/1996 03:00:00
14/04/1996 04:00:00
14/04/1996 05:00:00
14/04/1996 06:00:00
14/04/1996 07:00:00
14/04/1996 08:00:00
14/04/1996 09:00:00
14/04/1996 10:00:00
14/04/1996 11:00:00
14/04/1996 12:00:00
14/04/1996 13:00:00
14/04/1996 14:00:00
14/04/1996 15:00:00
14/04/1996 16:00:00
14/04/1996 17:00:00
14/04/1996 18:00:00
14/04/1996 19:00:00
14/04/1996 20:00:00
14/04/1996 21:00:00
14/04/1996 22:00:00
14/04/1996 23:00:00
14/04/1996 00:00:00
15/04/1996 01:00:00
15/04/1996 02:00:00
15/04/1996 03:00:00
15/04/1996 04:00:00
15/04/1996 05:00:00
15/04/1996 06:00:00
15/04/1996 07:00:00
15/04/1996 08:00:00
15/04/1996 09:00:00
15/04/1996 10:00:00
15/04/1996 11:00:00
15/04/1996 12:00:00
15/04/1996 13:00:00
15/04/1996 14:00:00
15/04/1996 15:00:00
15/04/1996 16:00:00
15/04/1996 17:00:00
15/04/1996 18:00:00
15/04/1996 19:00:00
15/04/1996 20:00:00
15/04/1996 21:00:00
15/04/1996 22:00:00
15/04/1996 23:00:00
15/04/1996 00:00:00
16/04/1996 01:00:00
16/04/1996 02:00:00
16/04/1996 03:00:00
16/04/1996 04:00:00
16/04/1996 05:00:00
16/04/1996 06:00:00
16/04/1996 07:00:00
16/04/1996 08:00:00
16/04/1996 09:00:00
16/04/1996 10:00:00
16/04/1996 11:00:00
16/04/1996 12:00:00
16/04/1996 13:00:00
16/04/1996 14:00:00
16/04/1996 15:00:00
16/04/1996 16:00:00
16/04/1996 17:00:00
16/04/1996 18:00:00
16/04/1996 19:00:00
16/04/1996 20:00:00
16/04/1996 21:00:00
16/04/1996 22:00:00
16/04/1996 23:00:00
16/04/1996 00:00:00
17/04/1996 01:00:00
17/04/1996 02:00:00
17/04/1996 03:00:00
17/04/1996 04:00:00
17/04/1996 05:00:00
17/04/1996 06:00:00
17/04/1996 07:00:00
17/04/1996 08:00:00
17/04/1996 09:00:00
17/04/1996 10:00:00
17/04/1996 11:00:00
17/04/1996 12:00:00
17/04/1996 13:00:00
17/04/1996 14:00:00
17/04/1996 15:00:00
17/04/1996 16:00:00
17/04/1996 17:00:00
17/04/1996 18:00:00
17/04/1996 19:00:00
17/04/1996 20:00:00
17/04/1996 21:00:00
17/04/1996 22:00:00
17/04/1996 23:00:00
17/04/1996 00:00:00
18/04/1996 01:00:00
18/04/1996 02:00:00
18/04/1996 03:00:00
18/04/1996 04:00:00
18/04/1996 05:00:00
18/04/1996 06:00:00
18/04/1996 07:00:00
18/04/1996 08:00:00
18/04/1996 09:00:00
18/04/1996 10:00:00
18/04/1996 11:00:00
18/04/1996 12:00:00
18/04/1996 13:00:00
18/04/1996 14:00:00
18/04/1996 15:00:00
18/04/1996 16:00:00
18/04/1996 17:00:00
18/04/1996 18:00:00
18/04/1996 19:00:00
18/04/1996 20:00:00
18/04/1996 21:00:00
18/04/1996 22:00:00
18/04/1996 23:00:00
18/04/1996 00:00:00
19/04/1996 01:00:00
19/04/1996 02:00:00
19/04/1996 03:00:00
19/04/1996 04:00:00
19/04/1996 05:00:00
19/04/1996 06:00:00
19/04/1996 07:00:00
19/04/1996 08:00:00
19/04/1996 09:00:00
19/04/1996 10:00:00
19/04/1996 11:00:00
19/04/1996 12:00:00
19/04/1996 13:00:00
19/04/1996 14:00:00
19/04/1996 15:00:00
19/04/1996 16:00:00
19/04/1996 17:00:00
19/04/1996 18:00:00
19/04/1996 19:00:00
19/04/1996 20:00:00
19/04/1996 21:00:00
19/04/1996 22:00:00
19/04/1996 23:00:00
19/04/1996 00:00:00
20/04/1996 01:00:00
20/04/1996 02:00:00
20/04/1996 03:00:00
20/04/1996 04:00:00
20/04/1996 05:00:00
20/04/1996 06:00:00
20/04/1996 07:00:00
20/04/1996 08:00:00
20/04/1996 09:00:00
20/04/1996 10:00:00
20/04/1996 11:00:00
20/04/1996 12:00:00
20/04/1996 13:00:00
20/04/1996 14:00:00
20/04/1996 15:00:00
20/04/1996 16:00:00
20/04/1996 17:00:00
20/04/1996 18:00:00
20/04/1996 19:00:00
20/04/1996 20:00:00
20/04/1996 21:00:00
20/04/1996 22:00:00
20/04/1996 23:00:00
20/04/1996 00:00:00
21/04/1996 01:00:00
21/04/1996 02:00:00
21/04/1996 03:00:00
21/04/1996 04:00:00
21/04/1996 05:00:00
21/04/1996 06:00:00
21/04/1996 07:00:00
21/04/1996 08:00:00
21/04/1996 09:00:00
21/04/1996 10:00:00
21/04/1996 11:00:00
21/04/1996 12:00:00
21/04/1996 13:00:00
21/04/1996 14:00:00
21/04/1996 15:00:00
21/04/1996 16:00:00
21/04/1996 17:00:00
21/04/1996 18:00:00
21/04/1996 19:00:00
21/04/1996 20:00:00
21/04/1996 21:00:00
21/04/1996 22:00:00
21/04/1996 23:00:00
21/04/1996 00:00:00
22/04/1996 01:00:00
22/04/1996 02:00:00
22/04/1996 03:00:00
22/04/1996 04:00:00
22/04/1996 05:00:00
22/04/1996 06:00:00
22/04/1996 07:00:00
22/04/1996 08:00:00
22/04/1996 09:00:00
22/04/1996 10:00:00
22/04/1996 11:00:00
22/04/1996 12:00:00
22/04/1996 13:00:00
22/04/1996 14:00:00
22/04/1996 15:00:00
22/04/1996 16:00:00
22/04/1996 17:00:00
22/04/1996 18:00:00
22/04/1996 19:00:00
22/04/1996 20:00:00
22/04/1996 21:00:00
22/04/1996 22:00:00
22/04/1996 23:00:00
22/04/1996 00:00:00
23/04/1996 01:00:00
23/04/1996 02:00:00
23/04/1996 03:00:00
23/04/1996 04:00:00
23/04/1996 05:00:00
23/04/1996 06:00:00
23/04/1996 07:00:00
23/04/1996 08:00:00
23/04/1996 09:00:00
23/04/1996 10:00:00
23/04/1996 11:00:00
23/04/1996 12:00:00
23/04/1996 13:00:00
23/04/1996 14:00:00
23/04/1996 15:00:00
23/04/1996 16:00:00
23/04/1996 17:00:00
23/04/1996 18:00:00
23/04/1996 19:00:00
23/04/1996 20:00:00
23/04/1996 21:00:00
23/04/1996 22:00:00
23/04/1996 23:00:00
23/04/1996 00:00:00
24/04/1996 01:00:00
24/04/1996 02:00:00
24/04/1996 03:00:00
24/04/1996 04:00:00
24/04/1996 05:00:00
24/04/1996 06:00:00
24/04/1996 07:00:00
24/04/1996 08:00:00
24/04/1996 09:00:00
24/04/1996 10:00:00
24/04/1996 11:00:00
24/04/1996 12:00:00
24/04/1996 13:00:00
24/04/1996 14:00:00
24/04/1996 15:00:00
24/04/1996 16:00:00
24/04/1996 17:00:00
24/04/1996 18:00:00
24/04/1996 19:00:00
24/04/1996 20:00:00
24/04/1996 21:00:00
24/04/1996 22:00:00
24/04/1996 23:00:00
24/04/1996 00:00:00
25/04/1996 01:00:00
25/04/1996 02:00:00
25/04/1996 03:00:00
25/04/1996 04:00:00
25/04/1996 05:00:00
25/04/1996 06:00:00
25/04/1996 07:00:00
25/04/1996 08:00:00
25/04/1996 09:00:00
25/04/1996 10:00:00
25/04/1996 11:00:00
25/04/1996 12:00:00
25/04/1996 13:00:00
25/04/1996 14:00:00
25/04/1996 15:00:00
25/04/1996 16:00:00
25/04/1996 17:00:00
25/04/1996 18:00:00
25/04/1996 19:00:00
25/04/1996 20:00:00
25/04/1996 21:00:00
25/04/1996 22:00:00
25/04/1996 23:00:00
25/04/1996 00:00:00
26/04/1996 01:00:00
26/04/1996 02:00:00
26/04/1996 03:00:00
26/04/1996 04:00:00
26/04/1996 05:00:00
26/04/1996 06:00:00
26/04/1996 07:00:00
26/04/1996 08:00:00
26/04/1996 09:00:00
26/04/1996 10:00:00
26/04/1996 11:00:00
26/04/1996 12:00:00
26/04/1996 13:00:00
26/04/1996 14:00:00
26/04/1996 15:00:00
26/04/1996 16:00:00
26/04/1996 17:00:00
26/04/1996 18:00:00
26/04/1996 19:00:00
26/04/1996 20:00:00
26/04/1996 21:00:00
26/04/1996 22:00:00
26/04/1996 23:00:00
26/04/1996 00:00:00
27/04/1996 01:00:00
27/04/1996 02:00:00
27/04/1996 03:00:00
27/04/1996 04:00:00
27/04/1996 05:00:00
27/04/1996 06:00:00
27/04/1996 07:00:00
27/04/1996 08:00:00
27/04/1996 09:00:00
27/04/1996 10:00:00
27/04/1996 11:00:00
27/04/1996 12:00:00
27/04/1996 13:00:00
27/04/1996 14:00:00
27/04/1996 15:00:00
27/04/1996 16:00:00
27/04/1996 17:00:00
27/04/1996 18:00:00
27/04/1996 19:00:00
27/04/1996 20:00:00
27/04/1996 21:00:00
27/04/1996 22:00:00
27/04/1996 23:00:00
27/04/1996 00:00:00
28/04/1996 01:00:00
28/04/1996 02:00:00
28/04/1996 03:00:00
28/04/1996 04:00:00
28/04/1996 05:00:00
28/04/1996 06:00:00
28/04/1996 07:00:00
28/04/1996 08:00:00
28/04/1996 09:00:00
28/04/1996 10:00:00
28/04/1996 11:00:00
28/04/1996 12:00:00
28/04/1996 13:00:00
28/04/1996 14:00:00
28/04/1996 15:00:00
28/04/1996 16:00:00
28/04/1996 17:00:00
28/04/1996 18:00:00
28/04/1996 19:00:00
28/04/1996 20:00:00
28/04/1996 21:00:00
28/04/1996 22:00:00
28/04/1996 23:00:00
28/04/1996 00:00:00
29/04/1996 01:00:00
29/04/1996 02:00:00
29/04/1996 03:00:00
29/04/1996 04:00:00
29/04/1996 05:00:00
29/04/1996 06:00:00
29/04/1996 07:00:00
29/04/1996 08:00:00
29/04/1996 09:00:00
29/04/1996 10:00:00
29/04/1996 11:00:00
29/04/1996 12:00:00
29/04/1996 13:00:00
29/04/1996 14:00:00
29/04/1996 15:00:00
29/04/1996 16:00:00
29/04/1996 17:00:00
29/04/1996 18:00:00
29/04/1996 19:00:00
29/04/1996 20:00:00
29/04/1996 21:00:00
29/04/1996 22:00:00
29/04/1996 23:00:00
29/04/1996 00:00:00
30/04/1996 01:00:00
30/04/1996 02:00:00
30/04/1996 03:00:00
30/04/1996 04:00:00
30/04/1996 05:00:00
30/04/1996 06:00:00
30/04/1996 07:00:00
30/04/1996 08:00:00
30/04/1996 09:00:00
30/04/1996 10:00:00
30/04/1996 11:00:00
30/04/1996 12:00:00
30/04/1996 13:00:00
30/04/1996 14:00:00
30/04/1996 15:00:00
30/04/1996 16:00:00
30/04/1996 17:00:00
30/04/1996 18:00:00
30/04/1996 19:00:00
30/04/1996 20:00:00
30/04/1996 21:00:00
30/04/1996 22:00:00
30/04/1996 23:00:00
30/04/1996 00:00:00

Can you help me how to do this by using macro?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Not sure if that would work for you.
Given in A1 the first datetime
in A2 formula is =A1+0.041667
 
Upvote 0
I wrote the following code with the assumption that A1 is the beginning of your dataset. So make sure you have data in A1 and A2 before running this code. The code is dependent on A1 and A2 having values and they have to be consecutive values. By consecutive values I mean exactly what you did in your example.
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]01/04/1996 01:00:00
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD]01/04/1996 02:00:00
[/TD]
[/TR]
</tbody>[/TABLE]
As long as you have consecutive values like in both of those cells, the code will work as expected.

Code:
Sub monthAddMacro()
    'Add 1 month to A1 and A2
    Dim varCounter As Integer
    varCounter = 1
    Range("A" & varCounter).Select
    Dim varDate As Date
    varDate = Range("A" & varCounter).Value
    Dim varOutput As Date
    varOutput = DateAdd("m", 1, varDate)
    ActiveCell.FormulaR1C1 = varOutput
    varCounter = varCounter + 1
    Range("A" & varCounter).Select
    varDate = Range("A" & varCounter).Value
    varOutput = DateAdd("m", 1, varDate)
    ActiveCell.FormulaR1C1 = varOutput
    ' Determine last day of month
    date_test = CDate(varOutput)
    var_month = Month(date_test)
    var_year = Year(date_test)
    date_next_month = DateSerial(var_year, var_month + 1, 1)
    last_day_month = date_next_month - 1
    nb_days = Day(last_day_month)
    ' Copy formatting down
    nb_days = nb_days * 24 - 1
    Range("A1:A2").Select
    Selection.AutoFill Destination:=Range("A1:A" & nb_days), Type:=xlFillDefault
    ' Remove extra cells
    Do While nb_days < 743
    Range("A" & nb_days + 1).Select
    Selection.ClearContents
    nb_days = nb_days + 1
    Loop
    Range("A" & nb_days).Select
End Sub
 
Upvote 0
Dear WarPiglet,

Thanks for reply. I've tried the code above. But it didn't work. I got this results:

Code:
[TABLE="width: 127"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]01/05/1996 01:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 02:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 03:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 04:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 05:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 06:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 07:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 08:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 09:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 10:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 11:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 12:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 13:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 14:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 15:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 16:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 17:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 18:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 19:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 20:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 21:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 22:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/1996 23:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 00:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 01:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 02:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 03:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 04:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 05:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 06:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 07:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 08:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 09:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 10:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 11:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 12:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 13:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 14:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 15:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 16:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 17:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 18:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 19:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 20:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 21:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 22:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/05/1996 23:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 00:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 01:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 02:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 03:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 04:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 05:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 06:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 07:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 08:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 09:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 10:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 11:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 12:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 13:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 14:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 15:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 16:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 17:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 18:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 19:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 20:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 21:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 22:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/1996 23:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 00:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 01:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 02:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 03:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 04:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 05:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 06:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 07:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 08:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 09:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 10:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 11:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 12:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 13:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 14:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 15:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 16:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 17:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 18:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 19:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 20:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 21:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 22:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/1996 23:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 00:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 01:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 02:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 03:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 04:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 05:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 06:00:00[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]09/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]10/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 14:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 15:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 16:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 17:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 18:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 19:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 20:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 21:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 22:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/1996 23:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 00:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 01:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 02:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 03:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 04:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 05:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 06:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 07:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 08:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 09:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 10:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 11:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 12:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 13:00:01[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]16/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/1996 23:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 00:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 01:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 02:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 03:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 04:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 05:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 06:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 07:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 08:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 09:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 10:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 11:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 12:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 13:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 14:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 15:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 16:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 17:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 18:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 19:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 20:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 21:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 22:00:02[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]23/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]24/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 07:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 08:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 09:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 10:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 11:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 12:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 13:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 14:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 15:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 16:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 17:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 18:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 19:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 20:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 21:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 22:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/1996 23:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 00:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 01:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 02:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 03:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 04:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 05:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 06:00:03[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 07:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 08:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 09:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 10:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 11:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 12:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 13:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 14:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 15:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 16:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 17:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 18:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 19:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 20:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 21:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 22:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]30/05/1996 23:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 00:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 01:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 02:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 03:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 04:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 05:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 06:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 07:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 08:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 09:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 10:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 11:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 12:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 13:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 14:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 15:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 16:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 17:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 18:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 19:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 20:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 21:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 22:00:04[/TD]
[/TR]
[TR]
[TD="align: right"]31/05/1996 23:00:04[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]01/05/1996 01:00:00
01/05/1996 02:00:00
01/05/1996 03:00:00
01/05/1996 04:00:00
01/05/1996 05:00:00
01/05/1996 06:00:00
01/05/1996 07:00:00
01/05/1996 08:00:00
01/05/1996 09:00:00
01/05/1996 10:00:00
01/05/1996 11:00:00
01/05/1996 12:00:00
01/05/1996 13:00:00
01/05/1996 14:00:00
01/05/1996 15:00:00
01/05/1996 16:00:00
01/05/1996 17:00:00
01/05/1996 18:00:00
01/05/1996 19:00:00
01/05/1996 20:00:00
01/05/1996 21:00:00
01/05/1996 22:00:00
01/05/1996 23:00:00
02/05/1996 00:00:00
02/05/1996 01:00:00
02/05/1996 02:00:00
02/05/1996 03:00:00
02/05/1996 04:00:00
02/05/1996 05:00:00
02/05/1996 06:00:00
02/05/1996 07:00:00
02/05/1996 08:00:00
02/05/1996 09:00:00
02/05/1996 10:00:00
02/05/1996 11:00:00
02/05/1996 12:00:00
02/05/1996 13:00:00
02/05/1996 14:00:00
02/05/1996 15:00:00
02/05/1996 16:00:00
02/05/1996 17:00:00
02/05/1996 18:00:00
02/05/1996 19:00:00
02/05/1996 20:00:00
02/05/1996 21:00:00
02/05/1996 22:00:00
02/05/1996 23:00:00
03/05/1996 00:00:00
03/05/1996 01:00:00
03/05/1996 02:00:00
03/05/1996 03:00:00
03/05/1996 04:00:00
03/05/1996 05:00:00
03/05/1996 06:00:00
03/05/1996 07:00:00
03/05/1996 08:00:00
03/05/1996 09:00:00
03/05/1996 10:00:00
03/05/1996 11:00:00
03/05/1996 12:00:00
03/05/1996 13:00:00
03/05/1996 14:00:00
03/05/1996 15:00:00
03/05/1996 16:00:00
03/05/1996 17:00:00
03/05/1996 18:00:00
03/05/1996 19:00:00
03/05/1996 20:00:00
03/05/1996 21:00:00
03/05/1996 22:00:00
03/05/1996 23:00:00
04/05/1996 00:00:00
04/05/1996 01:00:00
04/05/1996 02:00:00
04/05/1996 03:00:00
04/05/1996 04:00:00
04/05/1996 05:00:00
04/05/1996 06:00:00
04/05/1996 07:00:00
04/05/1996 08:00:00
04/05/1996 09:00:00
04/05/1996 10:00:00
04/05/1996 11:00:00
04/05/1996 12:00:00
04/05/1996 13:00:00
04/05/1996 14:00:00
04/05/1996 15:00:00
04/05/1996 16:00:00
04/05/1996 17:00:00
04/05/1996 18:00:00
04/05/1996 19:00:00
04/05/1996 20:00:00
04/05/1996 21:00:00
04/05/1996 22:00:00
04/05/1996 23:00:00
05/05/1996 00:00:00
05/05/1996 01:00:00
05/05/1996 02:00:00
05/05/1996 03:00:00
05/05/1996 04:00:00
05/05/1996 05:00:00
05/05/1996 06:00:00
05/05/1996 07:00:01
05/05/1996 08:00:01
05/05/1996 09:00:01
05/05/1996 10:00:01
05/05/1996 11:00:01
05/05/1996 12:00:01
05/05/1996 13:00:01
05/05/1996 14:00:01
05/05/1996 15:00:01
05/05/1996 16:00:01
05/05/1996 17:00:01
05/05/1996 18:00:01
05/05/1996 19:00:01
05/05/1996 20:00:01
05/05/1996 21:00:01
05/05/1996 22:00:01
05/05/1996 23:00:01
06/05/1996 00:00:01
06/05/1996 01:00:01
06/05/1996 02:00:01
06/05/1996 03:00:01
06/05/1996 04:00:01
06/05/1996 05:00:01
06/05/1996 06:00:01
06/05/1996 07:00:01
06/05/1996 08:00:01
06/05/1996 09:00:01
06/05/1996 10:00:01
06/05/1996 11:00:01
06/05/1996 12:00:01
06/05/1996 13:00:01
06/05/1996 14:00:01
06/05/1996 15:00:01
06/05/1996 16:00:01
06/05/1996 17:00:01
06/05/1996 18:00:01
06/05/1996 19:00:01
06/05/1996 20:00:01
06/05/1996 21:00:01
06/05/1996 22:00:01
06/05/1996 23:00:01
07/05/1996 00:00:01
07/05/1996 01:00:01
07/05/1996 02:00:01
07/05/1996 03:00:01
07/05/1996 04:00:01
07/05/1996 05:00:01
07/05/1996 06:00:01
07/05/1996 07:00:01
07/05/1996 08:00:01
07/05/1996 09:00:01
07/05/1996 10:00:01
07/05/1996 11:00:01
07/05/1996 12:00:01
07/05/1996 13:00:01
07/05/1996 14:00:01
07/05/1996 15:00:01
07/05/1996 16:00:01
07/05/1996 17:00:01
07/05/1996 18:00:01
07/05/1996 19:00:01
07/05/1996 20:00:01
07/05/1996 21:00:01
07/05/1996 22:00:01
07/05/1996 23:00:01
08/05/1996 00:00:01
08/05/1996 01:00:01
08/05/1996 02:00:01
08/05/1996 03:00:01
08/05/1996 04:00:01
08/05/1996 05:00:01
08/05/1996 06:00:01
08/05/1996 07:00:01
08/05/1996 08:00:01
08/05/1996 09:00:01
08/05/1996 10:00:01
08/05/1996 11:00:01
08/05/1996 12:00:01
08/05/1996 13:00:01
08/05/1996 14:00:01
08/05/1996 15:00:01
08/05/1996 16:00:01
08/05/1996 17:00:01
08/05/1996 18:00:01
08/05/1996 19:00:01
08/05/1996 20:00:01
08/05/1996 21:00:01
08/05/1996 22:00:01
08/05/1996 23:00:01
09/05/1996 00:00:01
09/05/1996 01:00:01
09/05/1996 02:00:01
09/05/1996 03:00:01
09/05/1996 04:00:01
09/05/1996 05:00:01
09/05/1996 06:00:01
09/05/1996 07:00:01
09/05/1996 08:00:01
09/05/1996 09:00:01
09/05/1996 10:00:01
09/05/1996 11:00:01
09/05/1996 12:00:01
09/05/1996 13:00:01
09/05/1996 14:00:01
09/05/1996 15:00:01
09/05/1996 16:00:01
09/05/1996 17:00:01
09/05/1996 18:00:01
09/05/1996 19:00:01
09/05/1996 20:00:01
09/05/1996 21:00:01
09/05/1996 22:00:01
09/05/1996 23:00:01
10/05/1996 00:00:01
10/05/1996 01:00:01
10/05/1996 02:00:01
10/05/1996 03:00:01
10/05/1996 04:00:01
10/05/1996 05:00:01
10/05/1996 06:00:01
10/05/1996 07:00:01
10/05/1996 08:00:01
10/05/1996 09:00:01
10/05/1996 10:00:01
10/05/1996 11:00:01
10/05/1996 12:00:01
10/05/1996 13:00:01
10/05/1996 14:00:01
10/05/1996 15:00:01
10/05/1996 16:00:01
10/05/1996 17:00:01
10/05/1996 18:00:01
10/05/1996 19:00:01
10/05/1996 20:00:01
10/05/1996 21:00:01
10/05/1996 22:00:01
10/05/1996 23:00:01
11/05/1996 00:00:01
11/05/1996 01:00:01
11/05/1996 02:00:01
11/05/1996 03:00:01
11/05/1996 04:00:01
11/05/1996 05:00:01
11/05/1996 06:00:01
11/05/1996 07:00:01
11/05/1996 08:00:01
11/05/1996 09:00:01
11/05/1996 10:00:01
11/05/1996 11:00:01
11/05/1996 12:00:01
11/05/1996 13:00:01
11/05/1996 14:00:01
11/05/1996 15:00:01
11/05/1996 16:00:01
11/05/1996 17:00:01
11/05/1996 18:00:01
11/05/1996 19:00:01
11/05/1996 20:00:01
11/05/1996 21:00:01
11/05/1996 22:00:01
11/05/1996 23:00:01
12/05/1996 00:00:01
12/05/1996 01:00:01
12/05/1996 02:00:01
12/05/1996 03:00:01
12/05/1996 04:00:01
12/05/1996 05:00:01
12/05/1996 06:00:01
12/05/1996 07:00:01
12/05/1996 08:00:01
12/05/1996 09:00:01
12/05/1996 10:00:01
12/05/1996 11:00:01
12/05/1996 12:00:01
12/05/1996 13:00:01
12/05/1996 14:00:01
12/05/1996 15:00:01
12/05/1996 16:00:01
12/05/1996 17:00:01
12/05/1996 18:00:01
12/05/1996 19:00:01
12/05/1996 20:00:01
12/05/1996 21:00:01
12/05/1996 22:00:01
12/05/1996 23:00:01
13/05/1996 00:00:01
13/05/1996 01:00:01
13/05/1996 02:00:01
13/05/1996 03:00:01
13/05/1996 04:00:01
13/05/1996 05:00:01
13/05/1996 06:00:01
13/05/1996 07:00:01
13/05/1996 08:00:01
13/05/1996 09:00:01
13/05/1996 10:00:01
13/05/1996 11:00:01
13/05/1996 12:00:01
13/05/1996 13:00:01
13/05/1996 14:00:02
13/05/1996 15:00:02
13/05/1996 16:00:02
13/05/1996 17:00:02
13/05/1996 18:00:02
13/05/1996 19:00:02
13/05/1996 20:00:02
13/05/1996 21:00:02
13/05/1996 22:00:02
13/05/1996 23:00:02
14/05/1996 00:00:02
14/05/1996 01:00:02
14/05/1996 02:00:02
14/05/1996 03:00:02
14/05/1996 04:00:02
14/05/1996 05:00:02
14/05/1996 06:00:02
14/05/1996 07:00:02
14/05/1996 08:00:02
14/05/1996 09:00:02
14/05/1996 10:00:02
14/05/1996 11:00:02
14/05/1996 12:00:02
14/05/1996 13:00:02
14/05/1996 14:00:02
14/05/1996 15:00:02
14/05/1996 16:00:02
14/05/1996 17:00:02
14/05/1996 18:00:02
14/05/1996 19:00:02
14/05/1996 20:00:02
14/05/1996 21:00:02
14/05/1996 22:00:02
14/05/1996 23:00:02
15/05/1996 00:00:02
15/05/1996 01:00:02
15/05/1996 02:00:02
15/05/1996 03:00:02
15/05/1996 04:00:02
15/05/1996 05:00:02
15/05/1996 06:00:02
15/05/1996 07:00:02
15/05/1996 08:00:02
15/05/1996 09:00:02
15/05/1996 10:00:02
15/05/1996 11:00:02
15/05/1996 12:00:02
15/05/1996 13:00:02
15/05/1996 14:00:02
15/05/1996 15:00:02
15/05/1996 16:00:02
15/05/1996 17:00:02
15/05/1996 18:00:02
15/05/1996 19:00:02
15/05/1996 20:00:02
15/05/1996 21:00:02
15/05/1996 22:00:02
15/05/1996 23:00:02
16/05/1996 00:00:02
16/05/1996 01:00:02
16/05/1996 02:00:02
16/05/1996 03:00:02
16/05/1996 04:00:02
16/05/1996 05:00:02
16/05/1996 06:00:02
16/05/1996 07:00:02
16/05/1996 08:00:02
16/05/1996 09:00:02
16/05/1996 10:00:02
16/05/1996 11:00:02
16/05/1996 12:00:02
16/05/1996 13:00:02
16/05/1996 14:00:02
16/05/1996 15:00:02
16/05/1996 16:00:02
16/05/1996 17:00:02
16/05/1996 18:00:02
16/05/1996 19:00:02
16/05/1996 20:00:02
16/05/1996 21:00:02
16/05/1996 22:00:02
16/05/1996 23:00:02
17/05/1996 00:00:02
17/05/1996 01:00:02
17/05/1996 02:00:02
17/05/1996 03:00:02
17/05/1996 04:00:02
17/05/1996 05:00:02
17/05/1996 06:00:02
17/05/1996 07:00:02
17/05/1996 08:00:02
17/05/1996 09:00:02
17/05/1996 10:00:02
17/05/1996 11:00:02
17/05/1996 12:00:02
17/05/1996 13:00:02
17/05/1996 14:00:02
17/05/1996 15:00:02
17/05/1996 16:00:02
17/05/1996 17:00:02
17/05/1996 18:00:02
17/05/1996 19:00:02
17/05/1996 20:00:02
17/05/1996 21:00:02
17/05/1996 22:00:02
17/05/1996 23:00:02
18/05/1996 00:00:02
18/05/1996 01:00:02
18/05/1996 02:00:02
18/05/1996 03:00:02
18/05/1996 04:00:02
18/05/1996 05:00:02
18/05/1996 06:00:02
18/05/1996 07:00:02
18/05/1996 08:00:02
18/05/1996 09:00:02
18/05/1996 10:00:02
18/05/1996 11:00:02
18/05/1996 12:00:02
18/05/1996 13:00:02
18/05/1996 14:00:02
18/05/1996 15:00:02
18/05/1996 16:00:02
18/05/1996 17:00:02
18/05/1996 18:00:02
18/05/1996 19:00:02
18/05/1996 20:00:02
18/05/1996 21:00:02
18/05/1996 22:00:02
18/05/1996 23:00:02
19/05/1996 00:00:02
19/05/1996 01:00:02
19/05/1996 02:00:02
19/05/1996 03:00:02
19/05/1996 04:00:02
19/05/1996 05:00:02
19/05/1996 06:00:02
19/05/1996 07:00:02
19/05/1996 08:00:02
19/05/1996 09:00:02
19/05/1996 10:00:02
19/05/1996 11:00:02
19/05/1996 12:00:02
19/05/1996 13:00:02
19/05/1996 14:00:02
19/05/1996 15:00:02
19/05/1996 16:00:02
19/05/1996 17:00:02
19/05/1996 18:00:02
19/05/1996 19:00:02
19/05/1996 20:00:02
19/05/1996 21:00:02
19/05/1996 22:00:02
19/05/1996 23:00:02
20/05/1996 00:00:02
20/05/1996 01:00:02
20/05/1996 02:00:02
20/05/1996 03:00:02
20/05/1996 04:00:02
20/05/1996 05:00:02
20/05/1996 06:00:02
20/05/1996 07:00:02
20/05/1996 08:00:02
20/05/1996 09:00:02
20/05/1996 10:00:02
20/05/1996 11:00:02
20/05/1996 12:00:02
20/05/1996 13:00:02
20/05/1996 14:00:02
20/05/1996 15:00:02
20/05/1996 16:00:02
20/05/1996 17:00:02
20/05/1996 18:00:02
20/05/1996 19:00:02
20/05/1996 20:00:02
20/05/1996 21:00:02
20/05/1996 22:00:02
20/05/1996 23:00:02
21/05/1996 00:00:02
21/05/1996 01:00:02
21/05/1996 02:00:02
21/05/1996 03:00:02
21/05/1996 04:00:02
21/05/1996 05:00:02
21/05/1996 06:00:02
21/05/1996 07:00:02
21/05/1996 08:00:02
21/05/1996 09:00:02
21/05/1996 10:00:02
21/05/1996 11:00:02
21/05/1996 12:00:02
21/05/1996 13:00:02
21/05/1996 14:00:02
21/05/1996 15:00:02
21/05/1996 16:00:02
21/05/1996 17:00:02
21/05/1996 18:00:02
21/05/1996 19:00:02
21/05/1996 20:00:02
21/05/1996 21:00:02
21/05/1996 22:00:02
21/05/1996 23:00:03
22/05/1996 00:00:03
22/05/1996 01:00:03
22/05/1996 02:00:03
22/05/1996 03:00:03
22/05/1996 04:00:03
22/05/1996 05:00:03
22/05/1996 06:00:03
22/05/1996 07:00:03
22/05/1996 08:00:03
22/05/1996 09:00:03
22/05/1996 10:00:03
22/05/1996 11:00:03
22/05/1996 12:00:03
22/05/1996 13:00:03
22/05/1996 14:00:03
22/05/1996 15:00:03
22/05/1996 16:00:03
22/05/1996 17:00:03
22/05/1996 18:00:03
22/05/1996 19:00:03
22/05/1996 20:00:03
22/05/1996 21:00:03
22/05/1996 22:00:03
22/05/1996 23:00:03
23/05/1996 00:00:03
23/05/1996 01:00:03
23/05/1996 02:00:03
23/05/1996 03:00:03
23/05/1996 04:00:03
23/05/1996 05:00:03
23/05/1996 06:00:03
23/05/1996 07:00:03
23/05/1996 08:00:03
23/05/1996 09:00:03
23/05/1996 10:00:03
23/05/1996 11:00:03
23/05/1996 12:00:03
23/05/1996 13:00:03
23/05/1996 14:00:03
23/05/1996 15:00:03
23/05/1996 16:00:03
23/05/1996 17:00:03
23/05/1996 18:00:03
23/05/1996 19:00:03
23/05/1996 20:00:03
23/05/1996 21:00:03
23/05/1996 22:00:03
23/05/1996 23:00:03
24/05/1996 00:00:03
24/05/1996 01:00:03
24/05/1996 02:00:03
24/05/1996 03:00:03
24/05/1996 04:00:03
24/05/1996 05:00:03
24/05/1996 06:00:03
24/05/1996 07:00:03
24/05/1996 08:00:03
24/05/1996 09:00:03
24/05/1996 10:00:03
24/05/1996 11:00:03
24/05/1996 12:00:03
24/05/1996 13:00:03
24/05/1996 14:00:03
24/05/1996 15:00:03
24/05/1996 16:00:03
24/05/1996 17:00:03
24/05/1996 18:00:03
24/05/1996 19:00:03
24/05/1996 20:00:03
24/05/1996 21:00:03
24/05/1996 22:00:03
24/05/1996 23:00:03
25/05/1996 00:00:03
25/05/1996 01:00:03
25/05/1996 02:00:03
25/05/1996 03:00:03
25/05/1996 04:00:03
25/05/1996 05:00:03
25/05/1996 06:00:03
25/05/1996 07:00:03
25/05/1996 08:00:03
25/05/1996 09:00:03
25/05/1996 10:00:03
25/05/1996 11:00:03
25/05/1996 12:00:03
25/05/1996 13:00:03
25/05/1996 14:00:03
25/05/1996 15:00:03
25/05/1996 16:00:03
25/05/1996 17:00:03
25/05/1996 18:00:03
25/05/1996 19:00:03
25/05/1996 20:00:03
25/05/1996 21:00:03
25/05/1996 22:00:03
25/05/1996 23:00:03
26/05/1996 00:00:03
26/05/1996 01:00:03
26/05/1996 02:00:03
26/05/1996 03:00:03
26/05/1996 04:00:03
26/05/1996 05:00:03
26/05/1996 06:00:03
26/05/1996 07:00:03
26/05/1996 08:00:03
26/05/1996 09:00:03
26/05/1996 10:00:03
26/05/1996 11:00:03
26/05/1996 12:00:03
26/05/1996 13:00:03
26/05/1996 14:00:03
26/05/1996 15:00:03
26/05/1996 16:00:03
26/05/1996 17:00:03
26/05/1996 18:00:03
26/05/1996 19:00:03
26/05/1996 20:00:03
26/05/1996 21:00:03
26/05/1996 22:00:03
26/05/1996 23:00:03
27/05/1996 00:00:03
27/05/1996 01:00:03
27/05/1996 02:00:03
27/05/1996 03:00:03
27/05/1996 04:00:03
27/05/1996 05:00:03
27/05/1996 06:00:03
27/05/1996 07:00:03
27/05/1996 08:00:03
27/05/1996 09:00:03
27/05/1996 10:00:03
27/05/1996 11:00:03
27/05/1996 12:00:03
27/05/1996 13:00:03
27/05/1996 14:00:03
27/05/1996 15:00:03
27/05/1996 16:00:03
27/05/1996 17:00:03
27/05/1996 18:00:03
27/05/1996 19:00:03
27/05/1996 20:00:03
27/05/1996 21:00:03
27/05/1996 22:00:03
27/05/1996 23:00:03
28/05/1996 00:00:03
28/05/1996 01:00:03
28/05/1996 02:00:03
28/05/1996 03:00:03
28/05/1996 04:00:03
28/05/1996 05:00:03
28/05/1996 06:00:03
28/05/1996 07:00:03
28/05/1996 08:00:03
28/05/1996 09:00:03
28/05/1996 10:00:03
28/05/1996 11:00:03
28/05/1996 12:00:03
28/05/1996 13:00:03
28/05/1996 14:00:03
28/05/1996 15:00:03
28/05/1996 16:00:03
28/05/1996 17:00:03
28/05/1996 18:00:03
28/05/1996 19:00:03
28/05/1996 20:00:03
28/05/1996 21:00:03
28/05/1996 22:00:03
28/05/1996 23:00:03
29/05/1996 00:00:03
29/05/1996 01:00:03
29/05/1996 02:00:03
29/05/1996 03:00:03
29/05/1996 04:00:03
29/05/1996 05:00:03
29/05/1996 06:00:03
29/05/1996 07:00:03
29/05/1996 08:00:03
29/05/1996 09:00:03
29/05/1996 10:00:03
29/05/1996 11:00:03
29/05/1996 12:00:03
29/05/1996 13:00:03
29/05/1996 14:00:03
29/05/1996 15:00:03
29/05/1996 16:00:03
29/05/1996 17:00:03
29/05/1996 18:00:03
29/05/1996 19:00:03
29/05/1996 20:00:03
29/05/1996 21:00:03
29/05/1996 22:00:03
29/05/1996 23:00:03
30/05/1996 00:00:03
30/05/1996 01:00:03
30/05/1996 02:00:03
30/05/1996 03:00:03
30/05/1996 04:00:03
30/05/1996 05:00:03
30/05/1996 06:00:03
30/05/1996 07:00:04
30/05/1996 08:00:04
30/05/1996 09:00:04
30/05/1996 10:00:04
30/05/1996 11:00:04
30/05/1996 12:00:04
30/05/1996 13:00:04
30/05/1996 14:00:04
30/05/1996 15:00:04
30/05/1996 16:00:04
30/05/1996 17:00:04
30/05/1996 18:00:04
30/05/1996 19:00:04
30/05/1996 20:00:04
30/05/1996 21:00:04
30/05/1996 22:00:04
30/05/1996 23:00:04
31/05/1996 00:00:04
31/05/1996 01:00:04
31/05/1996 02:00:04
31/05/1996 03:00:04
31/05/1996 04:00:04
31/05/1996 05:00:04
31/05/1996 06:00:04
31/05/1996 07:00:04
31/05/1996 08:00:04
31/05/1996 09:00:04
31/05/1996 10:00:04
31/05/1996 11:00:04
31/05/1996 12:00:04
31/05/1996 13:00:04
31/05/1996 14:00:04
31/05/1996 15:00:04
31/05/1996 16:00:04
31/05/1996 17:00:04
31/05/1996 18:00:04
31/05/1996 19:00:04
31/05/1996 20:00:04
31/05/1996 21:00:04
31/05/1996 22:00:04
31/05/1996 23:00:04




[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
As you can see above, the month should be April change to May.
For time 24:00:00, I hope it did not change to 00:00:00 and the date also not change to the next day.
Why the seconds increase?

When I did manually, I also faced this problem. Can you help me edit that macro? I've tried change it a bit but I also got it wrong.
 
Upvote 0
Question: why the date is not 02/04/1996 00:00:00 after 01/04/1996 23:00??

On the other hand, you may consider using Fill to perform the task without using VBA.

Example:
in A1, input the 1st cell vaule, i.e. 01/04/1996 01:00
Go to Home Tab --> Editing Group --> Fill --> Series..
Series in Columns
Step value: 0.0416666667
Stop value: 35186
(35186 stands for the date of 01/05/1996. You may obtain the number but simply inputting the date and format it as General)
OK





date

01/04/1996 23:00:00
01/04/1996 00:00:00


Can you help me how to do this by using macro?
 
Upvote 0
Suyah,
In your original post, you wanted a way to increment hours for an entire month. So the first cell in your column would be dd/mm/yyyy hh:mm:ss
01/10/2010 01:00:00
You can change the date, but the date needs to be the first of the month and the time needs to be 1:00:00.
Each cell under it increments 1 hour based on that cell.
01/10/2012 01:00:00
...
01/10/2010 23:00:00
02/10/2010 00:00:00
Then at 00:00:00, the date changes to the next day.
The column continues to populate for threat entire month but stops before going into next month.
You can change the date in the top 2 cells to change the dataset for another month.

Now to answer your recent questions more directly.
You said that at 00:00:00, it did not change to the next day. From what I can tell in the dataset that you posted, it did change to the next day.
You asked why the seconds were increased. I have no idea. I ran this code myself before giving it to you and it did not do that. Later on I'll run it again to double check, but I'm not on my computer right now.
 
Upvote 0
Alright so I made a lot of modifications to the original code. The original code has too much room for user error. For example, if you entered a date that wasn't the first day of the month, it would not work as expected. If you entered a different time other than 1:00:00 as the first cell, it would also not work as expected. I fixed all that with this code below. Now you can enter anything such as 8/24/2010 11:00:00 AM
Code:
Sub monthAddMacro()
    'Add 1 month to A1
    Dim varCounter As Integer
    varCounter = 1
    Range("A" & varCounter).Select
    Dim varDate As Date
    varDate = Range("A" & varCounter).Value
    Dim varOutput As Date
    varOutput = DateAdd("m", 1, varDate)
    ActiveCell.FormulaR1C1 = varOutput
    ' Determine last day of month
    date_test = CDate(varOutput)
    var_month = Month(date_test)
    var_year = Year(date_test)
    date_next_month = DateSerial(var_year, var_month + 1, 1)
    last_day_month = date_next_month - 1
    nb_days = Day(last_day_month)
    nb_days = nb_days - Day(Range("A1").Value) + 1
    ' Populate column
    Do While varCounter < (nb_days * 24) - 1
    varCounter = varCounter + 1
    Range("A" & varCounter).Select
    varCounter = varCounter - 1
    varDate = Range("A" & varCounter).Value
    ActiveCell.FormulaR1C1 = DateAdd("h", 1, varDate)
    varCounter = varCounter + 1
    If Month(Range("A" & varCounter).Value) <> Month(Range("A1").Value) Then
    Range("A" & varCounter).Select
    Selection.ClearContents
    End If
    Loop
    ' Remove extra cells
    nb_days = nb_days * 24
    Do While nb_days - 1 < 744
    Range("A" & nb_days).Select
    nb_days = nb_days + 1
    Selection.ClearContents
    Loop
    Range("A1").Select
End Sub
 
Upvote 0
cyrilbrd was right that you don't need a macro. I wish I would have thought of this first before I spent all that time making you that macro I just posted. His formula was a bit off because it added an extra second every so often, but I added some 6s to the formula and it works fine now. Forget the macro. Not that it doesn't work, it's just unnecessary.
Enter this formula into A2...
Code:
=IFERROR(IF(MONTH($A$1)=MONTH(A1+0.04166666),A1+0.04166666,""),"")
Click the bottom right corner of the A2 cell and drag the formula all the way down to cell A743.
You now have a dynamic list. That was way easier than the macro.
 
Upvote 0
cyrilbrd was right that you don't need a macro. I wish I would have thought of this first before I spent all that time making you that macro I just posted. His formula was a bit off because it added an extra second every so often, but I added some 6s to the formula and it works fine now. Forget the macro. Not that it doesn't work, it's just unnecessary.
Enter this formula into A2...
Code:
=IFERROR(IF(MONTH($A$1)=MONTH(A1+0.04166666),A1+0.04166666,""),"")
Click the bottom right corner of the A2 cell and drag the formula all the way down to cell A743.
You now have a dynamic list. That was way easier than the macro.

Your VBA was a good move however it could have be done with fill series as suggested by mfexcel.
Yes 0.041667 might be a bit off, but the idea was just to set OP toward a simple method.
in A1, input the 1st cell vaule, i.e. 01/04/1996 01:00
Go to Home Tab --> Editing Group --> Fill --> Series..
Series in Columns
Step value: 0.0416666667
Stop value: 35186
(35186 stands for the date of 01/05/1996. You may obtain the number but simply inputting the date and format it as General)

Is simply perfect for this thread.
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top