Stuck!,

Use John Walkenbach's extended date difference add-in, available at

http://www.j-walk.com/ss/excel/files/xdate.htm

HTH,
Bernie
MS Excel MVP


"stuck!" wrote in message
...
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!