+ Reply to Thread
Results 1 to 3 of 3

Military Time:Is there a formula that would easily convert it?

  1. #1
    Sue
    Guest

    Military Time:Is there a formula that would easily convert it?

    I am trying to convert cells containing military time to regular time. Ex.
    1430 to 2:30. Is there a formula that would easily convert it? Thanks!

  2. #2
    Niek Otten
    Guest

    re: Military Time:Is there a formula that would easily convert it?

    http://www.cpearson.com/excel/DateTimeEntry.htm

    --

    Kind Regards,

    Niek Otten

    Microsoft MVP - Excel

    "Sue" <Sue@discussions.microsoft.com> wrote in message
    news:369994CD-A309-42F4-BF75-517374EE301E@microsoft.com...
    >I am trying to convert cells containing military time to regular time. Ex.
    > 1430 to 2:30. Is there a formula that would easily convert it? Thanks!




  3. #3
    JE McGimpsey
    Guest

    re: Military Time:Is there a formula that would easily convert it?

    One way:

    =TIME(INT(A1/100),MOD(A1,100),0)

    In article <369994CD-A309-42F4-BF75-517374EE301E@microsoft.com>,
    Sue <Sue@discussions.microsoft.com> wrote:

    > I am trying to convert cells containing military time to regular time. Ex.
    > 1430 to 2:30. Is there a formula that would easily convert it? Thanks!


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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