View Single Post
  #2   Report Post  
Brian
 
Posts: n/a
Default

Nevermind. Seached other questions - found if I set ToolsOptions to 1904
calendar the calculation will show negative! Don't know why but it does!.
Brian

"Brian" wrote:

Is there a way to report negative "time". Example: I paid my employee
80:00:00 hours estimate (cell a1). He actually worked 72:00:00 hours (cell
a2). He owes me 8:00:00 (cell a3) where (a3 = a2-a1). Problem is i get
###### instead of minus 8 hours or -8:00:00. Thanks in advance.