Excel provides two options for calculating the difference between two times. If you use a simple subtraction operation such as "=C1-A1," select the custom format "h:mm" from the Format Cells options.

4. Addition and Subtraction Lastly, addition and subtraction are handled from left to right. For example, in the formula =5+3-2, Excel first adds 5 and 3, which results in 8.