You can display negative time unless you change your setting in the
Calculation Tab to use the 1904 time system (default in the MAC). This will
change any existing dates in any workbook you open to be off by 4 years (if
they used the other system).

[hh] will allow excel to display time in excess of 24 hours. (but I doubt
it solves your current problem).

--
Regards,
Tom Ogilvy



"neowok " wrote in message
...
ok ill have a look at that (think ive got the formula worked out now.

whats the difference between [hh]:mm and hh:mm ? im guessing [hh] will
accept negative values?


---
Message posted from http://www.ExcelForum.com/