question about entering date and time

[changetires]

Can you enter date and time into a cell like this, I want to be able t
enter the time in military format without the colon..... ex.(dd/mm/yyy
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]

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

 

[patele]

Thanks for covering my back David