Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

The serial number for the end time is greater than 1, because adding 12.5 hours to 7 PM takes you into the next day. However, because cell C2 is formatted to only display the time, only the part ...