Add Times in Microsoft Excel
You might be keeping track of the time you spend working on a task or project. When that work is complete, you’ll want the total time you spent. Whether for your own records or for billing a client, you can use a combination of formulas and formatting to get accurate time totals.

Format the Cells for Hours and Minutes
Note that we’ll be using the structure H:MM to stay consistent with the timekeeping of hours and minutes. While Excel should recognize this when you enter your data, you can make sure of it by formatting your cells.

Select the cells containing your entries and either right-click and pick “Format Cells” or go to the Home tab, click “Format” in the ribbon, and choose “Format Cells.”

In the Format Cells window, make sure that you’re on the Number tab. Select “Custom” as the Category. Then, select “h:mm” from the list or enter the format into the Type box.

Click “OK” to apply the format to the cells.

Add Times Using a Formula

If you only have a couple of entries, you can enter a quick formula to add those hours and minutes.

Select the cell where you want your time to go. Enter the following formula, replacing the cell references with your own.

=F2+F3

Hit Enter to apply the formula and you should see your total hours and minutes for those entries.