By default Excel doesn't allow negative times (or dates) but you can use negative time if you switch to 1904 date system. To do this
Tools > Options > Calculation > 1904 date System
Be careful if you change to this. Any existing dates in your worksheet will change by 4 years.
Another option would be to use decimals rather than time format, i.e. -18.5 rather than -18:30
Bookmarks