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

Posted by Pepor on Super User See other posts from Super User or by Pepor
Published on 2008-08-22T06:15:40Z Indexed on 2011/01/02 17:55 UTC
Read the original article Hit count: 200

Filed under:
|
|

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 cannot be displayed as a time value. Even OpenOffice.org Calc and Google Spreadsheets can display negative time values.

Is there a way to work around that issue by using conditional formatting? I really don't want to create some workaround by calculating the hours and minutes myself or anything like that.

© Super User or respective owner

Related posts about excel

Related posts about time