Question: how do i calculate time difference in excel after midnight?
Answer: When times cross midnight By subtracting the start time from 1, you get the amount of time in the first day, which you can simply add to the amount of time in the 2nd day, which is the same as the end time. Now when both times are in the same day, end is greater than start time, so the simple formula is used.