+ Reply to Thread
Results 1 to 6 of 6

how can add date this formula convert military time to normal time

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

    how can add date this formula convert military time to normal time

    please i have date in B3 want to add to this formula
    =TIME(TRUNC(B4/100),MOD(B4,100),0) instead make convert in one cell then in other sum
    i try the following but not work
    =TIME(TRUNC(B4/100),MOD(B4,100),0)+b3

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,814

    Re: how can add date this formula convert military time to normal time

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: how can add date this formula convert military time to normal time

    Maybe attach an example spreadsheet showing some data and what you expect to see (Go Advanced>Manage Attachments)
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

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

    Re: how can add date this formula convert military time to normal time

    thanks for your reply
    please see my attahced file
    want to make b1 and b2 in one step
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,814

    Re: how can add date this formula convert military time to normal time

    Try

    =A2+TIME(TRUNC(A1/100),MOD(A1,100),0)

    format as dd/mm/yyyy hh:mm (or your desired format)

  6. #6
    Registered User
    Join Date
    07-27-2017
    Location
    Canada
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Re: how can add date this formula convert military time to normal time

    Right click on the cell A2 -> Format Cell, select what's in the picture attached
    Capture.PNG

+ 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. Replies: 7
    Last Post: 06-19-2017, 06:10 PM
  2. how to convert time if it's past midnight in military time
    By Jomejorada in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-15-2015, 07:50 AM
  3. Formula to convert military time into hh:mm format
    By javiere77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2015, 12:17 PM
  4. [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
  5. 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
  6. 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
  7. [SOLVED] Military Time:Is there a formula that would easily convert it?
    By Sue in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2005, 01:06 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