View Single Post
  #1   Report Post  
stuck!
 
Posts: n/a
Default How do i enter negative times in Excel & how can they be 'fiddled.

How do i enter negative times in Excel & how can they be 'fiddled with' to
allow SUM functions etc... to work correctly? When I try to enter a negative
time in time format [h]:mm an error message pops up saying put a ' in front
.. This does allow the negative time to be entered but when this cell is
incorporated in a SUM funtion it is ignored. There is probably a simple
solutionto this, but as an excel novice it has me stuck!