answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: 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?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Natural Sciences

When plants perform photosynthesis they use sunlight to produce food. This is an example of light energy being converted to?

It is converted to chemical energy. They are in bonds of glucose


What is 1800 est?

By the military tradition, 1800 hours is the same as 6:00 pm, and EST is Eastern Standard Time, the time zone of the eastern coast of the US (New York for example is in that time zone).


What is the disadvantage of having a hubble space telescope?

The cost. Of course, this cost is puny compared with military expenditures, for example, but there still is a cost.The cost. Of course, this cost is puny compared with military expenditures, for example, but there still is a cost.The cost. Of course, this cost is puny compared with military expenditures, for example, but there still is a cost.The cost. Of course, this cost is puny compared with military expenditures, for example, but there still is a cost.


What is involuntary joints?

Where they work automatically (I.E intestines, liver) <--- they are example of involentry organs


When plants perform photosynthesis they usually use sunlight to produce foodthis is an example of light energy being converted to?

Photosynthesis is an example of the conversion of light energy to chemical energy.

Related questions

What is one situation where gravitational potential energy might be useful?

For example, in a hydroelectric power plant, where it is converted into electricity.For example, in a hydroelectric power plant, where it is converted into electricity.For example, in a hydroelectric power plant, where it is converted into electricity.For example, in a hydroelectric power plant, where it is converted into electricity.


What type of magazine do you need for High Standard Pistol Supermatic Citation Model 107 Military?

Any of the Military grip models will take a magazine with a longer floor plate. For example: http://www.ammoclip.com/H/high_stand_military_grips.htm


What is an example of military custom?

Saluting the national flag of the countryis an example of a military custom.


What is an example of a military custom?

Saluting the national flag of the countryis an example of a military custom.


How do you calcuate standard deviation?

A worked out example is shown in the related link. There are a number of calculators that do this automatically. Also, the Excel program (and most other spreadsheet programs) include a standard deviation function. In Excel, it is +stdev(a1:a10) for a list of numbers from a1 to a10.


What is an example of solar energy being converted into chemical energy?

Green plants producing sugars is an example of solar engery being converted into chemical energy.


What was the build up of the US military in 1916 and example of?

The build-up of the U.S. military was an example of preparedness.


The date you change a file is an example of a property?

automatically updated


Can you repaint an unconverted neopet without it being converted For example I have an unconverted plushie shoyru and I paint him red will he be converted now or stay unconverted xD?

The pet will be converted.


Which cellular standard is an example of a 2.5G transitional standard?

GPRS


What is an example of Electric energy converted into mechanical energy?

The most familiar example of this is running an electric motor.


Examples of the law of conservationof energy?

Since energy is ALWAYS conserved, anything that happens is an "example". For example, an object just sitting around. However, it is usually more interesting to analyze what happens when one type of energy is converted to another. For example, if a car brakes, the car's kinetic energy is converted to heat (in the brakes); when you throw an object up, kinetic energy is converted to potential energy; when it falls back down, the potential energy is converted back to kinetic energy; and if in this example there is air resistance, part of the kinetic energywill be converted to heat.