+ Reply to Thread
Results 1 to 6 of 6

add number of hour to time in military format

  1. 07-25-2016, 04:47 AM #1
    mazan2010
    mazan2010 is offline
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    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
    Reply With QuoteRegister To Reply
  2. 07-25-2016, 04:58 AM #2
    José Augusto
    José Augusto is offline
    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
    Reply With QuoteRegister To Reply
  3. 07-25-2016, 04:58 AM #3
    José Augusto
    José Augusto is offline
    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
    Reply With QuoteRegister To Reply
  4. 07-25-2016, 04:59 AM #4
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,843

    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.
    Reply With QuoteRegister To Reply
  5. 07-25-2016, 05:02 AM #5
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,899

    Re: add number of hour to time in military format

    Try this ...

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

    Format cells -> [h]:mm
    Reply With QuoteRegister To Reply
  6. 07-25-2016, 05:05 AM #6
    mazan2010
    mazan2010 is offline
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: add number of hour to time in military format

    thanks all
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Rounding time to nearest half hour, military format, 10:46 should round to 11:00 etc
    By harknessa in forum Excel Formulas & Functions
    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. How to I convert standard time to Military or 24 hour format?
    By Nacho in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1