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!