How to sum time in excel and display total hours correctly

Steps to Sum Time and Format as Total Hours in Excel

Step 1: Enter the Data

Column A → Task Names

Column B → Time Spent (e.g., 11:30, 09:55, 5:00, etc.)

Step 2: Use the SUM Formula

Below the time values (e.g., in B8), enter the formula:
 =SUM(B1:B7)

Press Enter, and Excel will sum the total time.

Step 3: Format as Total Hours

1. Click on Cell B8 (where the total time is displayed).
2. Go to Home > Number Format (dropdown menu).
3. Click on More Number Formats.

Select Custom, then enter the format:
[h]:MM

4. Click OK.

Now, the total time will be displayed in hours and minutes, correctly summing all the task durations! 🚀

Example:-