View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DazedandConfused DazedandConfused is offline
external usenet poster
 
Posts: 1
Default Negative and Positive Time

I have a cell in whic the formula may return a positive time or negative time
depending on the hours worked.
I can format the cell to display a positive time or a negative time but not
to switch between the 2.
I have tried formatting the cell to h:mm;(h:mm) and using the 1904 date
system but neither work
HELP!!!!!