Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Convert Standard Time In Military Time

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!

  • #2
    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?

    Comment


    • #3
      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.

      Comment


      • #4
        Re: Convert Standard Time In Military Time

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

        =A1*24

        Richard

        Comment


        • #5
          Re: Convert Standard Time In Military Time

          I tried that, I get:

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

          Comment


          • #6
            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

            Comment


            • #7
              Re: Convert Standard Time In Military Time

              Ok, that seems to be working.

              Thanks!

              Comment

              Trending

              Collapse

              There are no results that meet this criteria.

              Working...
              X