I need a simple formula to convert standard time (1:05pm) into military time (13:08).

I've read through several posts, but all I've found is reformatting or time subtraction type information. The reformating works to an extent, it gives me the hours in military but the minutes stay standard.

Basicly, all I need is:

Cell A1 = 1:05 p

Cell B1 = formula that shows/converts 1:05 p as 13:08

Can someone direct me to a helpful post or help me with this?

Thanks!

I've read through several posts, but all I've found is reformatting or time subtraction type information. The reformating works to an extent, it gives me the hours in military but the minutes stay standard.

Basicly, all I need is:

Cell A1 = 1:05 p

Cell B1 = formula that shows/converts 1:05 p as 13:08

Can someone direct me to a helpful post or help me with this?

Thanks!

- Converting standard time to military
- Converting Standard Time to Military Time in Excel
- How do i convert standard time format into seconds?
- How to I convert standard time to Military or 24 hour format?
- Convert Standard Time with AM/PM to Military Time
- Military Time Conversion to Standard Time
- Formula to remove text and convert from standard time to a decimal
- Show timesheet time in and out in regular time versus military tim
- Show timesheet time in and out in regular time versus military tim
- Displaying time in a combo box
- Converting EST time in IST
- Convert Text Times In 1 Cell
- Convert min/km in km/h
- Convert EST time into MST
- Military time to Standard Time
- Do not convert 24hr time in Excel to Portugese postal code
- Converting military times to numbers
- Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
- Convert time in decimal format
- Convert date to length of time in months from set date
- Converting a time format to a String format in Excel
- Convert standard number to time format
- Adding time in 24 hour format to produce hours in decimal format
- Convert Formula result in Time Format

3/30/2011 2:00:00 PM To be clear the date and time share the same cell.

I would like to convert the time into military time, for instance the above example would read:

3/30/2011 14:00 (do not need the seconds though it will not hurt either)

Thaks very much

Military Time in Excel?

Is it a formula or formatting?

formula to do this in excel.

24 hour format i.e. 15:00. How can I do this?

Originally, I had a date/time field mm/dd/yy hh:mm AM/PM. I extracted that data to a date field and a time field. Perhaps that wasn't the best way?

Thank you for your expert help.

Lonnie

Thank you!!!

I need help with a formula. As of now, I have a column with standard time. For instance, the column looks like:

7:58 AM (CDT)

4:24 PM (CDT)

etc.

I am looking to remove "(CDT)" from the text. I know the formula for that would be something like =LEFT(Column, # of characters). However, I would also like to convert the standard time to military time, and then I want to convert the times into a decimal. Is there a way I can do all of this in one formula? Thank you for your help.

military time, Col D is labeled â€˜Outâ€™ for stop time in military time, Col E

is total hours worked with formula beginning in row 10, where data input

begins, as =D10-C10+(D10

military time, Col D is labeled â€˜Outâ€™ for stop time in military time, Col E

is total hours worked with formula beginning in row 10, where data input

begins, as =D10-C10+(D10<C10). Also on row 10. in Col F is labeled â€˜Inâ€™ for

start time in military time, Col G is labeled â€˜Outâ€™ for stop time in military

time, Col H is total hours worked with formula =G10-F10+(G10<F10). Col I has

the total of columns E and H with the formula =E10+H10. Data in rows C, D, E,

F, G, H is formatted Custom h:mm and data in Col I is formatted [h]:mm. I

would like to have the times in Columns C through H to read as regular time

(such as 2:25PM as opposed to 14:25).

--

John T. Sullivan

I am trying to determine the time difference from two combo boxes in which i

pick a start time from one combo box and an end time from the second combo

box. I can do this, but i would like the user to be able to see the times in

standard time, not military. I have already tried formatiing it from VBA,

but i can't seem to figure out where my problem is at? Any help would be

greatly appreciated.

Thanks.

Linda

12:00AM

12:30AM

1:00AM

1:30AM

2:00AM

2:30AM

3:00AM

I want to convert these times into (IST +9:30) and put them in A1:a7

Sheshadri

I've searched and found almost what i'm after but not quite

i have a list of times in word in a column

they are in the following textformat 12 23 00 23 14 34

i can paste them into excel but cant work out how to change them to excel time eg 12:23 00:23 14:34

thanks if anyone can help

How can i convert a time in minute km in km/h ?

thx

ex

minute km km/h

A2 0.04.00 B2 15,000

thx

ex

minute km km/h

A2 0.04.00 B2 15,000

For example, in column C, I have something like

92412 ---> So this is 9:24:12 AM

152209 ---> So this is 3:22:09 PM

I just want to change the format from military time to standard time so that I can do a sort.

Any help / advice would be greatly appreciated. Thank you.

'special' number format for Portugese postal code. Reformating does not

stay--reverts to Portugese postal code. Unaceptable to convert English

expression to foreign language. 24 hour time standard for military.

----------------

This post is a suggestion for Microsoft, and Microsoft responds to the

suggestions with the most votes. To vote for this suggestion, click the "I

Agree" button in the message pane. If you do not see the button, follow this

link to open the suggestion in the Microsoft Web-based Newsreader and then

click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

For example:

Right now the columns show the following:

0:01

0:23

2:14

13:32

19:54

Their actual values are:

12:01:00 AM

12:23:00 AM

2:14:00 AM

1:32:00 PM

7:54:00 PM

I want it to instead have the following values:

1

23

214

1332

1954

They should be formatted as numbers, with no indication that they represent times.

Is this possible?

I have a worksheet that contains military times in number format that I need to compare against.

Thanks.

Converting the dates and times in column A from GMT (Greenwich Mean Time) to CST (Central Standard Time).

CST is 6 hours earlier than GMT.

Solution:

Use the TIME function as shown in the following formula:

=A2-TIME(6,0,0)

For Eg: Min = Hour

1 = 0.022 = 0.033 = 0.0540:39 = 40.65

Conversion table file is attached for more information. Please took a look at it.

Procedure require through vba...

ilyaskazi

of time in months from a specified time?

Any help would be greatly appreciated.

Thanks,

MJ

Can somebody advise me if it is possible to convert a time formated cell to

a string in Excel?

--

Thanks

Bill Partridge

w/no colons and it would be converted to a normal time format 9:23 PM

to come up with flight hours in a decimal format across days (the date itself

is not important).

Example:

Takeoff 2231 to land 0138 the next morning is 3.1 hours of flight time and

would look like this:

T/O LAND Hours

2231 0138 3.1

The tenths of hours are standard flight time accounting and go like this:

0-5 min= .0, 6-11 min= .1, 12-17 min= .2, 18- 23 min= .3, 24-29 min= .4,

30-35 min= .5, 36-41 min= .6, 42-47 min= .7, 48-53 min= .8, and 54-59 min= .9.

I'll be using Excel 2002 to do this, if it can be done at all. Thanks in

advance.

No luck finding an answer? You could always try Google.