date time format

N

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.
 
B

Bonzo123

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

In the A2 type in

=A1+1/24

Drag this formula down

Regards
 
N

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
 
Top