Perform Time Calculations
Enter Your Times Type each of your times in its own cell, separating hours and minutes with a colon. When you select a time, you’ll see its corresponding time on a 12-hour clock displayed in the Formula Bar.
Enter a Formula Start a formula in a blank cell with =. Click a cell with a time to reference it in the formula, and use operators or Excel’s functions to work with the times. For example, click one time, type + and click a second time to add the times together.
Calculate Above 24 Hours
Excel defaults to adding hours on the clock, so 23:00 plus 1:00 results in 0:00 (midnight). To add hours together without this 24-hour limit, change the cell formatting on all cells containing times, including the formula cell. Select the cells, right-click any one and pick Format Cells. Choose Custom and enter [h]:mm. With this format, your hours won’t loop to 0 after reaching 24.
Display Military Time Formatting
Excel normally displays a colon between hours and minutes, and won’t show leading zeroes. To switch to military time formatting, write a custom cell format. Select your cells, right-click one and pick Format Cells. Select Custom and enter the format hhmm. With this format, times always appear as four digits without a colon. Writer Bio
