Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Convert Standard Time In Military Time

1. I agreed to these rules
Join Date
21st March 2006
Posts
13

## Convert Standard Time In Military Time

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!

Excel Video Tutorials / Excel Dashboards Reports

2. Join Date
18th September 2005
Location
Hampshire, UK
Posts
1,278

## Re: Convert Standard Time In Military Time

How do you get 8 from 5? I take it the 8 isn't actually a minute value?

Excel Video Tutorials / Excel Dashboards Reports

3. I agreed to these rules
Join Date
21st March 2006
Posts
13

## Re: Convert Standard Time In Military Time

It's 1/100 of a minute or something like that.

For example:
1:15p = 13:25
1:30p = 13:50
1:45p = 13:75

Basicly, you take the Standard Minute i.e. :05 divide by 60 and you get :08.

Excel Video Tutorials / Excel Dashboards Reports

4. Join Date
18th September 2005
Location
Hampshire, UK
Posts
1,278

## Re: Convert Standard Time In Military Time

Well, shouldn't you then be able to convert to the military time using:

=A1*24

Richard

Excel Video Tutorials / Excel Dashboards Reports

5. I agreed to these rules
Join Date
21st March 2006
Posts
13

## Re: Convert Standard Time In Military Time

I tried that, I get:

A1 - 1:05p
B1 - =A1*24 results 2:00 am

Excel Video Tutorials / Excel Dashboards Reports

6. Join Date
18th September 2005
Location
Hampshire, UK
Posts
1,278

## Re: Convert Standard Time In Military Time

When you do that calculation, you end up with a decimal value (ie it is not Excel time). You just need to amend to an appropriate number format eg Format>Cells>Number Tab, Custom Category and the 0.00 option, for example.

Richard

Excel Video Tutorials / Excel Dashboards Reports

7. I agreed to these rules
Join Date
21st March 2006
Posts
13

## Re: Convert Standard Time In Military Time

Ok, that seems to be working.

Thanks!

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno