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 ...

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.