+ Reply to Thread
Results 1 to 6 of 6

how to convert time if it's past midnight in military time

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    33

    how to convert time if it's past midnight in military time

    Hi, I'm trying to count the number of patients at a given hour

    7/27/2015 13:51
    7/28/2015 17:50


    13:51 17:50 (formula to convert this into 41:50) so patient will be counted every hour until 5:50 pm the following day

    Thank you!
    J

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: how to convert time if it's past midnight in military time

    13:51 to 17:50 next day should be 28:00 , why 41:50?
    Quang PT

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

    Re: how to convert time if it's past midnight in military time

    Hi
    Try to format the time differences using "mm:ss;@"
    I do not know if is ";" or ","
    Regards

  4. #4
    Registered User
    Join Date
    03-15-2013
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: how to convert time if it's past midnight in military time

    I added 24 hours to 17:50 because patient was here past midnight

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

    Re: how to convert time if it's past midnight in military time

    Hi Jomejorada
    You do not need to add 24h
    See the file
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-15-2013
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: how to convert time if it's past midnight in military time

    Hi everyone, thank you for all your responses. I really appreciate your time. But I guess I was not clear on what I needed so I am attaching a file that shows why I need to convert those times (highlighted) past midnight. I want to count number of patients in the unit by hour.

    Thank you!
    Attached Files Attached Files

+ 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] Text Time to Excel Format, Then Sort Time Past Midnight
    By BuntyMac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2014, 03:13 AM
  2. Figuring total hours in military time going passed midnight.
    By kradecki in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-17-2014, 09:47 AM
  3. [SOLVED] Military time pass midnight trouble
    By Jollibee in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-16-2013, 02:20 PM
  4. [SOLVED] Military Time Not Calculating after Midnight.
    By heresteve2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2013, 06:34 PM
  5. [SOLVED] Figuring total hours in military time going passed midnight.
    By NETSPY in forum Excel General
    Replies: 9
    Last Post: 07-09-2012, 05:59 PM
  6. Replies: 4
    Last Post: 01-11-2012, 07:59 PM
  7. [SOLVED] Calculating Time Past Midnight
    By Darren in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2006, 11:03 AM

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