Step by step
- Enter times in hh:mm format (such as 8:30 or 7:45) in a column.
- Use =SUM(A1:A10) to add them, then format the result cell as [h]:mm.
- Multiply the time cell by 24 and format as General or Number to get decimal hours.
- For a single timesheet check without formulas, type your hours into the calculator above.
At a glance
| Task | Excel formula | Format needed |
|---|---|---|
| Add hours past 24h | =SUM(A1:A10) | Custom [h]:mm |
| Time between two times | =B1-A1 | hh:mm |
| Convert to decimal hours | =A1*24 | General or Number |
| Subtract break from shift | =B1-A1-C1 | hh:mm |
Where to find it on your device
- Format cells in Excel: Home > Number > More Number Formats > Custom > [h]:mm
Related questions
Why does Excel show the wrong total after 24 hours?
By default, Excel wraps time totals back to zero every 24 hours. Changing the cell format to [h]:mm tells Excel to display cumulative hours instead of a time of day.
How do I convert hours and minutes to decimal hours in Excel?
Multiply the time cell by 24, for example =A1*24, and set the cell format to Number. A value of 7:45 becomes 7.75.
When is a browser hours calculator faster than Excel?
When you only need a quick total, decimal conversion, or shift calculation without opening a spreadsheet or fixing cell formats. You can type lines directly and see both hh:mm and decimal totals immediately.
More questions: hours calculator
- How to Calculate Hours Worked With a Lunch Break
- How to Convert Minutes to Decimal Hours
- How to Add and Subtract Hours and Minutes
- How to Calculate Pay From Hours Worked
- How to Calculate Weekly Hours Worked
- What Is an Hours Bank Arrangement and How to Calculate It
- How to Calculate Hours Worked on an Overnight Shift
Open the full hours calculator →
Updated November 14, 2026.