How to Display Excel Time Durations Over 24 Hours on iPad
Question details
The user needs to correctly display calculated time durations that exceed 24 hours in Excel on an iPad.
- Product
- Microsoft Excel
- Device & OS
- iPad
- Scenario
- Tracking work hours or calculating long durations where total times naturally exceed a single 24-hour day.
- Observed behavior
- Excel defaults to a standard time-of-day format, causing cumulative totals that cross the 24-hour mark to reset back to zero instead of displaying the total hours.
Select the specific cells containing your time calculations and ensure your iPad is connected to the internet to sync any formatting changes if you are using a cloud-stored workbook.
Apply Custom Number Format [h]:mm
Use a custom time format with bracketed hours to force the spreadsheet to display cumulative durations rather than resetting each day.
By default, Excel treats time as a specific moment in a 24-hour day. Wrapping the hour variable in square brackets tells the application to treat the value as an absolute duration.
Tap on the cell or drag the selection handles to highlight all the cells containing your calculated work durations on your iPad screen.
Tap the 'Home' tab on the ribbon at the top of the Excel app, then scroll to find and tap on 'Number Format'.
Scroll to the bottom of the format list and select 'Custom' (or tap 'More Number Formats' if applicable in your app version).
In the format string box, type exactly [h]:mm and apply the changes. The cell will now display total hours exceeding 24.
![Apply Custom Number Format [h]:mm](https://res-academy.cache.wpscdn.com/upload/seo-engine-admin/2026-10-23/cdaa1bc92d631d35e2a88805dfbeb986.png)
Easily Format Cumulative Time Over 24 Hours with WPS Office
WPS Office for iPad provides robust custom number formatting capabilities, allowing you to easily track and display cumulative hours exceeding 24 hours. Enjoy a familiar mobile interface without limitations.
- 1. Open Spreadsheet in WPS Office: Launch the WPS Office app on your iPad and open your timesheet or duration workbook.
- 2. Select the Duration Cells: Tap and drag to select the specific cells where your time totals are calculated.
- 3. Access Cell Format Settings: Tap the 'Tools' icon (four squares) in the bottom-left corner, navigate to the 'Home' tab, and tap 'Format Cells'.
- 4. Apply Custom Format: Go to the 'Number' section, select 'Custom', input [h]:mm into the text field, and confirm to display total hours.
Frequently Asked Questions
Why does my Excel time formula reset back to zero after 24 hours?
By default, Excel formats time values as a time of day (like on a 24-hour clock). Once a calculation exceeds 23:59, it rolls over to the next day and starts counting hours from zero. Applying the [h]:mm format changes it from 'time of day' to 'total duration'.
Can I display seconds along with hours and minutes for durations over 24 hours?
Yes, you can easily include seconds by adjusting the custom format. In the Custom Number format field, type [h]:mm:ss to track cumulative hours, minutes, and seconds accurately.
Is custom formatting fully supported on mobile spreadsheet apps for iPad?
While most premium mobile spreadsheet apps support basic custom number formatting like [h]:mm, some free or simplified versions may hide these settings deep in the menus. WPS Office for iPad provides straightforward access to custom cell formatting directly in the Home toolbar.
