Display Excel Time Values Longer Than 24 Hours
Question details
Display elapsed time values longer than 24 hours in Excel cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains elapsed time values that can exceed one day.
- Observed behavior
- A cell can display an elapsed time such as 33:12:00 while the formula bar shows the underlying value as a date and time.
Check that the cells contain numeric time values or formulas, not text. Select the cells you want to display as accumulated hours.
Apply an elapsed-time format in Excel
Use a custom number format to show accumulated hours beyond 24 without changing the stored value.
Select the time cells, right-click the selection, and choose Format Cells.
On the Number tab, select Custom and enter [h]:mm:ss in the Type box.
Click OK. A value representing one day plus 9 hours and 12 minutes will display as 33:12:00.

Display hours beyond 24 in WPS Spreadsheets
Use a custom number format in WPS Spreadsheets to display accumulated hours while preserving the numeric time value.
- 1. Open the workbook: Open your spreadsheet in WPS Spreadsheets and select the cells containing elapsed times.
- 2. Open cell formatting: Right-click the selected cells and choose Format Cells.
- 3. Enter the format: On the Number tab, choose Custom and enter [h]:mm:ss in the Type field.
- 4. Apply and check: Click OK and check that values longer than one day display as accumulated hours.

Frequently Asked Questions
Why does Excel show a date in the formula bar for an elapsed time?
Excel stores time as a fraction of a day. When the value exceeds one day, the formula bar may interpret it as a date and time even if the cell displays accumulated hours.
Why does my time display reset after 24 hours?
A format such as h:mm:ss displays the hour within a day. Select the cells, open Format Cells, and use the custom format [h]:mm:ss to display total elapsed hours.
Will Paste Values fix the time display?
No. Paste Values does not convert the stored time into accumulated hours. Apply [h]:mm:ss through Format Cells instead; the underlying numeric value remains unchanged.
Can I use the same format in WPS Spreadsheets?
Yes. Select the cells, open Format Cells, choose Custom, and enter [h]:mm:ss.




