Returning negative time values =SUM(D6-C6)

[phillexcel]

Cell C6 shows what time the agent should start at, ie. 08:30:00

D6 contains shows when the agent logged in, so for example 08:31:00

In cell E6 I have the formula =SUM(D6-C6) and this shows the variance as 00:01:00 which is fine.

However if the value in D6 is less than that In cell C6 I want it to show a negative time value but with the formula I have it just shows ############################

Please can anyone help me?

 

[VoG]

You need to use the 1904 date system XL: The 1900 Date System vs. the 1904 Date System

 

[Special-K99]

Solution here
How to display / show negative time properly in Excel?