View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kidsmeasy kidsmeasy is offline
external usenet poster
 
Posts: 7
Default change regular 24 hour format to military time in excel

for 6pm(1800) would be correct and that is the way i would like for it to
show in the cell.

"Meebers" wrote:

I thought they were the same. Give example of what you expect to see for 6
pm. (18:00)

"kidsmeasy" wrote in message
...
I am trying to create a format for military time in excel