Formatting Issues

How to Fix Excel Time Card Showing 28 Hours as 4:00

Nimra Malik Oct 21, 2026 869 views

Question details

Calculate total hours worked over 24 hours without the time format resetting to zero.

How to Fix Excel Time Card Showing 28 Hours as 4:00

Product: Excel
Device & OS: not provided
Scenario: Calculating employee time cards or weekly timesheets.
Observed behavior: When total hours exceed 24 (e.g., 28 hours), the cell displays the remainder (e.g., 4:00) instead of the cumulative total.

Before you start

Ensure your individual time entries are entered in a valid time format (like hh:mm) before applying custom formatting to the total sum cells.

Solution 1Recommended

Apply the Cumulative Hour Custom Format

Use the custom number format to display hours over 24 instead of rolling over to zero.

By default, standard time formats in spreadsheets reset every 24 hours because they are designed to reflect a time of day rather than a duration. By enclosing the hour indicator in brackets, you instruct the spreadsheet to calculate cumulative hours continuously.

Select the total cells

Highlight the cell or cells containing your total calculated hours on the time card.

Open Format Cells

Right-click the selected cell and choose 'Format Cells', or press Ctrl + 1 on your keyboard to open the formatting dialog.

Apply custom format

Navigate to the 'Number' tab, select 'Custom' from the category list, type [h]:mm into the Type box, and click OK.

Formula Tip: This cumulative formatting works perfectly with basic SUM formulas used to calculate total hours across multiple days.

Efficient Spreadsheet Management

Easily Manage Time Cards with WPS Spreadsheet

WPS Office provides powerful and highly compatible spreadsheet tools to handle custom formatting seamlessly, including cumulative time calculations for employee timesheets.

1. Open your file: Launch WPS Spreadsheet and open your employee timesheet document.
2. Select the cell: Highlight the cells containing the total hours that need fixing.
3. Format cells: Right-click the selection, choose 'Format Cells', and click on the Custom category.
4. Apply cumulative format: Enter [h]:mm into the input field and click OK to display cumulative hours correctly.

100% compatible with Microsoft Excel formats (.xlsx)Pre-built time and date formatting optionsSeamless handling of cumulative hours over 24Free, lightweight, and familiar user interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does my spreadsheet reset time after 24 hours?

By default, standard time formats operate on a 24-hour clock representing the time of day. Once the total reaches 24 hours, it rolls over to the next day, displaying only the remainder.

How can I display total hours with seconds included?

You can use the custom format [h]:mm:ss to display cumulative hours alongside both minutes and seconds.

Can I multiply cumulative hours by an hourly wage directly?

Because spreadsheets store time as fractions of a 24-hour day (e.g., 12 hours is stored as 0.5), you must multiply the total time cell by 24, and then multiply that result by the hourly wage (e.g., =(A1*24)*Wage) to calculate the correct pay.

Document & File Issues