FG
šŸ’» Software

Is there any way to properly display negative time spans in Excel?

Fresh7 days ago
Mar 15, 202626021 views
Confidence Score0%
0%

Problem

Is there any way to make Excel show a negative time span? If I subtract two time values (say, when subtracting the actual amount of time spent on something from the amount of time planned for it) and the result is negative, Excel just fills the result cell with hashes to notify me that the result cā€¦

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix ā€“ Awaiting Verification

Fix for: Is there any way to properly display negative time spans in Excel?

Low Risk

From http://spreadsheetpage.com/index.php/tip/C17/P10/ by John Walkenbach: By default, Excel uses a date system that begins with January 1, 1900. A negative time value generates a date-time combination that falls before this date, which is invalid. ā€¦

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment