Convert a Time Sum to Hours and Minutes in Excel
Question details
Convert a summed time value into separate total hours and remaining minutes in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user is converting a total displayed as hours and minutes into separate hour and minute values.
- Observed behavior
- The minutes carry over correctly, but the hours do not produce the expected total.
Check that the input cells contain Excel time values rather than text, and identify the cell containing the sum. The formulas below assume a nonnegative total in cell A1; replace A1 with your actual total cell.
Extract Total Hours and Remaining Minutes
Use formulas when you need the time sum split into two numeric values, including hours beyond 24.
Excel stores time as a fraction of a day. Multiplying the total by 24 converts it to hours, while MINUTE returns the remaining minute component.
Select an empty cell and enter =INT(A1*24), where A1 contains the summed time.
Select another empty cell and enter =MINUTE(A1). This returns the minute component from 0 to 59.
Select the two formula cells, then choose Home > Number Format > General or Number so the results appear as numeric hours and minutes.

Display the Accumulated Total Beyond 24 Hours
Use a custom time format when you only need to display the total rather than split it into separate cells.
Calculate Total Hours and Minutes in WPS Spreadsheets
Use WPS Spreadsheets to separate an accumulated time total into hours and minutes or display totals beyond 24 hours.
- 1. Open your spreadsheet: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Calculate total hours: In an empty cell, enter =INT(A1*24), replacing A1 with the cell containing your time sum.
- 3. Calculate remaining minutes: In another empty cell, enter =MINUTE(A1), using the same total cell reference.
- 4. Format the total if needed: Select the total cell, open Format Cells, and choose a custom format of [h]:mm to display accumulated hours.

Frequently Asked Questions
Why does my Excel time total start over after 24 hours?
A standard time format can display the hour component modulo 24. Select the total cell, open Format Cells > Number > Custom, and use [h]:mm to show accumulated hours.
How do I calculate total hours instead of the hour of the day?
For a nonnegative time total in A1, enter =INT(A1*24). Unlike HOUR(A1), this includes complete days in the hour count.
What formulas split 26:45 into hours and minutes?
If A1 contains the valid Excel time value displayed as 26:45, =INT(A1*24) returns 26 and =MINUTE(A1) returns 45.
Why are my formulas not working with the source times?
Check whether the source entries are stored as text rather than Excel time values. Also verify the cell references and compare the formula result with your expected hours and minutes.




