+ Reply to Thread
Results 1 to 6 of 6

add number of hour to time in military format

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    920

    add number of hour to time in military format

    all time in column b and C in format military
    i would like to add hour from D3 to B2 and put this function in C3
    please kindly find attached file
    Attached Files Attached Files

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: add number of hour to time in military format

    Hi
    I suppose you can use =D3+B2

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: add number of hour to time in military format

    Hi
    I suppose you can use =D3+B2

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: add number of hour to time in military format

    Excel can handle military time, just set the right format.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,798

    Re: add number of hour to time in military format

    Try this ...

    =TEXT(B2,"00\:00")+TEXT(D3,"00\:00")

    Format cells -> [h]:mm

  6. #6
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    920

    Re: add number of hour to time in military format

    thanks all

+ 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. [SOLVED] Extract hour from TIME in NON-Military time
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-17-2015, 08:45 AM
  2. [SOLVED] Covert date/time to military time hour only
    By toontown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2013, 01:05 PM
  3. Replies: 2
    Last Post: 01-22-2013, 02:05 PM
  4. Military/24 Hour Time Adding and difference finding
    By Squirrel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2011, 11:05 PM
  5. Military time range to decimal of hour
    By slopland in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2010, 03:25 AM
  6. Replies: 5
    Last Post: 06-28-2006, 02:20 PM
  7. Rounding military time to nearest tenth of an hour
    By rcterrell in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2005, 10:25 PM

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