Formatting Issues

Display Excel Time Values Longer Than 24 Hours

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 868 views

Question details

Display elapsed time values longer than 24 hours in Excel cells.

Display Excel Time Values Longer Than 24 Hours
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.
Before you start

Check that the cells contain numeric time values or formulas, not text. Select the cells you want to display as accumulated hours.

Solution 1Recommended

Apply an elapsed-time format in Excel

Use a custom number format to show accumulated hours beyond 24 without changing the stored value.

1
Open Format Cells

Select the time cells, right-click the selection, and choose Format Cells.

2
Choose a custom format

On the Number tab, select Custom and enter [h]:mm:ss in the Type box.

3
Apply the format

Click OK. A value representing one day plus 9 hours and 12 minutes will display as 33:12:00.

Apply an elapsed-time format in Excel
The formula bar may still show a date: Excel stores times as fractions of days, so the formula bar may show a date and time for values over 24 hours. The custom format changes the cell display, not the underlying value.
Format elapsed time in WPS

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. 1. Open the workbook: Open your spreadsheet in WPS Spreadsheets and select the cells containing elapsed times.
  2. 2. Open cell formatting: Right-click the selected cells and choose Format Cells.
  3. 3. Enter the format: On the Number tab, choose Custom and enter [h]:mm:ss in the Type field.
  4. 4. Apply and check: Click OK and check that values longer than one day display as accumulated hours.
Display elapsed hours beyond 24 with [h]:mm:ssKeep time values numeric for calculationsOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface
QA img-9

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.