How to automatically update the date to time

[mike]

Hope someone can help me with this one which I have been trying to work with
no success. Here is what I have in A1 I have a date and in B1 I have a time.
Is there away that I can have the spreadsheet automatically make the time of
0:00 and 11:00 to 11:59 place a date of 6/01/04 and then do the same thing
for the whole entire month.
date time
6/01/04 0:00
6/01/04 11:00 to 11:59 (any no. between)
6/02/04 0.00
6/02/04 11:00 to 11:59 (any no. between)
etc
etc
6/31/04 same
I am not to good in writing macro so if one is needed thanks a lot.

 

[Gord Dibben]

Mike

One method..

In A1 enter the date 6/01/04
In A2 enter =A1
In A3 enter =A1+1

Select A2 and A3 cells and drag/copy down Column A

Format Column B as Custom hh:mm

In B1 enter =A1
In B2 enter =B1+.499 which returns 11:58:34

Drag/copy down Column B

Gord Dibben Excel MVP