How to Do Time Intervals in Excel. When calculating time intervals in Excel, ... so you need to convert the format of the output cell to correctly display a time.