question about entering date and time

[changetires]

Can you enter date and time into a cell like this, I want to be able to enter the time in military format without the colon..... ex.(dd/mm/yyyy 0800)

[patele]

Try it like this:

Enter in the cell you need the Military date and time in as:

=NOW()

Then format it as:

dd/mm/yyyy hhmm

The result is:

18/Jul/2006 0630

Results of date and time will vary from computer to computer.

[David Biddulph]

"patele" <[email protected]> wrote in
message news:[email protected]...
>
> Try it like this:
>
> Enter in the cell you need the Military date and time in as:
>
> =NOW()
>
> Then format it as:
>
> dd/mm/yyyy hhmm
>
> The result is:
>
> 18/Jul/2006 0630
>
> Results of date and time will vary from computer to computer.

That format would probably give 18/07/2006 0630

If you want 18/Jul/2006 0630 try dd/mmm/yyyy hhmm
--
David Biddulph

[patele]

Thanks for covering my back David!