Thread: question about entering date and time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
patele patele is offline
external usenet poster
  
Posts: 1
Default question about entering date and time

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.


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=562056

Reply With QuoteReply With Quote