date time format

[nomi]

i wish to have dates and time in a column in such a way that after 24 hours
day changes and then again for next day i have 24 hours and so on. plz tell
how could i do this using excel.

[Bonzo123]

In address A1 type in
=today()+"00:00"

In the A2 type in

=A1+1/24

Drag this formula down

Regards

[nomi]

thanks a lot for ur response , however may it possible to display the hours
too like:
9/8/2005 01:00
9/8/2055 02:00
..
..
..
so on

"Bonzo123" wrote:

>
> In address A1 type in
> =today()+"00:00"
>
> In the A2 type in
>
> =A1+1/24
>
> Drag this formula down
>
> Regards
>
>
> --
> Bonzo123
> ------------------------------------------------------------------------
> Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182
> View this thread: http://www.excelforum.com/showthread...hreadid=465824
>
>

[nomi]

i wish to insert vlues from 1/1/1977 in this way ur method starts from "today"

"Bonzo123" wrote:

>
> In address A1 type in
> =today()+"00:00"
>
> In the A2 type in
>
> =A1+1/24
>
> Drag this formula down
>
> Regards
>
>
> --
> Bonzo123
> ------------------------------------------------------------------------
> Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182
> View this thread: http://www.excelforum.com/showthread...hreadid=465824
>
>