answersLogoWhite

0


Best Answer

You can format normal time to military time. For example you could have the time entered as:

13:00

If you then press Ctrl-1 to bring you to format cells and then go to Number and then Custom, you can change the format to:

hmm

It will now display the time as:

1300

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you use military time in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the use of time table in Microsoft Excel?

You can make a time table in Excel to show schedules of many things (trains, airplanes, etc.).


What Excel feature you can use to if you want to work with one record at a time?

Excel provides a data form feature that can allow you to work with one record at a time.


How many workbooks are open on the taskbar when you first install Excel?

No workbooks are open when you first install excel. The first time you use excel, you will have one workbook open.


How do you format in excel so that when you type in military time it is automatically converted to standard time For example you type in 1730 and when you click off of it it shows 530 PM?

You have to format the cell(s) in order to convert military time automatically over to standard time. In Excel, click on Format on the toolbar, then select what you want to format, then under the number tab find time and select how you want it to show up.


What tool can you use in Excel to automate time-consuming or tedious tasks?

Excel has many such tools, all fundamentally being formulas and functions.


Im an Excel expert?

If you would to be an Excel expert, just do this. Follow all the tutorials of MS excel in Microsoft's website. And USE Excel so much - with formulas, macros and pivots, you will be an Excel expert in no time. I did that and became an excel expert www.p2w2.com/chaitanya_sagar/index.php . Check it out.


What are five professons that use Microsoft Excel?

Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.


Does Brazil use military time?

Yes


Does Mexico use military time?

Yes.


Do radiological technician use Microsoft Excel?

Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.


Where can one find a tutorial on how to use the Exel VLOOKUP?

Tutorials on how to use the Excel VLOOKUP can be found on Spreadsheet Functions, Launch Excel, Time Atlas, Five Minute Lessons, Corality and Home and Learn.


Do hotels use Excel?

Any business can use Excel for a whole range of things.