+ Reply to Thread
Results 1 to 3 of 3

Military Time Format

  1. #1
    Registered User
    Join Date
    11-28-2011
    Location
    Israel
    MS-Off Ver
    Excel 2007
    Posts
    2

    Military Time Format

    Hi All,
    I'm using Excel's feature to increment time in constant steps (any value, actually). For example, I'm inserting the times:

    10:00:00,
    10:10:00,
    10:20:00,

    And let Excel perform the completion.

    My problem is that I need a military time formatץ That means ignoring the AM/PM notation.

    I can do it with Excel only if the system time format, the one you set in the control panel. The "secret" is not to use the tt in the format: hh:mm instead of hh:mm:tt.

    I was wondering if anyone has a better idea, that relays only on Excel and does not depend on the system formats.

    Thank you so very much in advance,
    Happy Holidays,
    Omer.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,635

    Re: Military Time Format

    Just format the cells as hh:mm
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-28-2011
    Location
    Israel
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Military Time Format

    Thanks. It works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1