close
Total hours available less hours worked each day, allow results to go
negative. Excel displays negative times as #.
You can generate negative times if you use the 1904 date system
Tools gt; Options gt; Calculation gt; 1904 date system
....although if you use on an existing worksheet it'll make all your
dates 4 years later!--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=509527
全站熱搜
留言列表
