Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Convert Standard Time In Military Time

  1. #1
    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. #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. #3
    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. #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. #5
    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. #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. #7
    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


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 7
    Last Post: November 23rd, 2007, 07:13
  2. Replies: 3
    Last Post: September 14th, 2007, 08:48
  3. Convert from Military time to Standard ET
    By Archie in forum EXCEL HELP
    Replies: 3
    Last Post: February 9th, 2005, 10:57
  4. Military Time
    By maxflia10 in forum OPEN SOURCE: Hey! That is Cool!
    Replies: 0
    Last Post: March 29th, 2003, 05:11
  5. Enter military time without colon
    By XL-Dennis in forum OPEN SOURCE: Hey! That is Cool!
    Replies: 0
    Last Post: March 21st, 2003, 22:51

Bookmarks

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