A total of more than twenty-four hours can appear to wrap around when formatted as a time of day. The stored duration may still be correct.
Inspect the underlying arithmetic
Confirm that the entries are numeric durations rather than text or complete timestamps. Sheets represents time as fractions of a day, so adding durations can produce a value greater than one.
For example, twelve hours plus fifteen hours totals twenty-seven hours. A clock-style display can show only the time component instead of the full elapsed total.
Apply a duration display
Select the total and choose Format > Number > Duration, or an appropriate reviewed elapsed-time custom format. Verify that the display retains accumulated hours rather than restarting at midnight.
Formatting does not repair text inputs or convert a clock reading into an elapsed duration. If a source contains the text 12 hours, first establish a reliable numeric representation rather than merely changing its cell style.
Check units and reporting rules
Test a total below twenty-four hours, exactly twenty-four, and above it. If a report needs decimal hours, multiply a duration in days by 24 in a separate numeric calculation.
Do not mix decimal hours such as 1.5 with time fractions representing 1:30 without conversion; they use different scales. Review negative durations and missing entries according to the workflow. Keep full timestamps when start and end dates matter, and separate unpaid breaks or excluded periods explicitly. A readable duration display should follow a verified calculation, not conceal an assumption that every shift begins and ends on the same calendar day.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.