How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Cris Your Own Question

Cris
Cris, Computer Systems Analyst
Category: Microsoft Office
Satisfied Customers: 6060
Experience:  Over 10yrs experience in Microsoft Office ranging from 2000-2010. Also similar products like OpenOffice.
10156100
Type Your Microsoft Office Question Here...
Cris is online now
A new question is answered every 9 seconds

Excel 2010 how do I convert am pm to military time?

Customer Question

Excel 2010 how do I convert am pm to military time?
Submitted: 3 years ago.
Category: Microsoft Office
Expert:  Cris replied 3 years ago.
Hi,

Thanks for using the site to ask your question, I am Cris.

There is no default, and Excel does not show a clock. You can format times in cells to show 24 hour time, by leaving out the AM/PM suffix in the format.

I hope this answers your question. Please reply back to me BEFORE selecting a negative rating. I will answer your follow ups.
Customer: replied 3 years ago.

not working


 


 

Expert:  Cris replied 3 years ago.
Right click on the cell(s) and select format cells from the menu.

Click on "Custom" on the left pane. Then select h:mm from the list.

Let me know how that works out for you.
Customer: replied 3 years ago.

Still not working

Expert:  Cris replied 3 years ago.
Can we do a remote connection so I can take a look at your issue?
Customer: replied 3 years ago.

ok

Expert:  Cris replied 3 years ago.
Great,

Please use the link below to reach join.me when you reach the site click on Start Meeting (Orange Play button). It will prompt you to download the software, when it finishes.

A join.me window will appear at the top of your screen with a 9-digit session number. Please reply back to me with it so I can join.

Click here>>>join.me
Expert:  Cris replied 3 years ago.
Were you able to get the session ID?