+ Reply to Thread
Results 1 to 2 of 2

Military time to standard time

  1. #1
    Registered User
    Join Date
    11-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Military time to standard time

    Hi everyone, I'm having a problem with a time sheet I'm working on. Let's just use cell A1 for example. I want to type 17:45 in the cell, and then I want the cell to display 5:45 PM when I click off of it. Any and all help would be greatly appreciated, thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: Military time to standard time

    Format the cell with the format you want it displayed as.
    I just tested it by entering 17:45 and it displayed 5:45 PM as you wanted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simple way to convert military time to standard where military has no colon
    By salvator in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2011, 10:27 AM
  2. Convert Standard Time with AM/PM to Military Time
    By LonnieJo1 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-11-2009, 07:20 PM
  3. Replies: 5
    Last Post: 06-28-2006, 02:20 PM
  4. Convert data into standard military time format
    By geog in forum Excel General
    Replies: 2
    Last Post: 12-12-2005, 03:50 PM
  5. Replies: 0
    Last Post: 08-23-2005, 12:22 PM

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