date time format
 

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.

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

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

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