Calculation Issues

Convert a Time Sum to Hours and Minutes in Excel

Kushani NimanthikaKushani Nimanthika Nov 18, 2026 871 views

Question details

Convert a summed time value into separate total hours and remaining minutes in Excel.

Convert a Time Sum to Hours and 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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the total hours formula

Select an empty cell and enter =INT(A1*24), where A1 contains the summed time.

2
Enter the remaining minutes formula

Select another empty cell and enter =MINUTE(A1). This returns the minute component from 0 to 59.

3
Format the results as numbers

Select the two formula cells, then choose Home > Number Format > General or Number so the results appear as numeric hours and minutes.

Extract Total Hours and Remaining Minutes
Check your expected result: These formulas return whole hours and the minute component; they do not include seconds. If the result is unexpected, compare the source times, current formula, and desired output.
Work with time totals in WPS

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. 1. Open your spreadsheet: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Calculate total hours: In an empty cell, enter =INT(A1*24), replacing A1 with the cell containing your time sum.
  3. 3. Calculate remaining minutes: In another empty cell, enter =MINUTE(A1), using the same total cell reference.
  4. 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.
Calculate total hours and remaining minutes in separate cellsDisplay accumulated time beyond 24 hoursOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface
QA img-9

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.