Subtract times and let result go negative
 

Total hours available less hours worked each day, allow results to go
negative. Excel displays negative times as #.

Subtract times and let result go negative
 

You can generate negative times if you use the 1904 date system

Tools Options Calculation 1904 date system

....although if you use on an existing worksheet it'll make all your
dates 4 years later!


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=509527