+ Reply to Thread
Results 1 to 2 of 2

Median of Two Times Over Midnight

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Median of Two Times Over Midnight

    Hello,

    I am trying to find the midpoint between two times. For example:

    10:38 PM and 6:20 AM

    When using the formula for Median, the cell has 2:29 PM instead of 2:29 AM.
    How do you account for the shift over midnight?

    Any help would be greatly appreciated! Thanks!

  2. #2
    Registered User
    Join Date
    08-13-2012
    Location
    Newark, DE
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Median of Two Times Over Midnight

    You can add a date to the time, as I did in the example below.

    A1: 9/10/2012 22:38
    A2: 9/11/2012 6:20
    A3: 2:29 AM
    A3: =MEDIAN(A1,A2)
    http://www.mrspreadsheets.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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