To change the date system, follow these steps: If, instead, you change to the 1904 date system (which is the default for Mac versions of Excel) then you'll see the correct negative elapsed time in your formula. This may sound goofy, but if you use a 1900 date system (which is the default for Windows versions of Excel), then you get the # in the cell. The easiest way to solve this problem is to just change the date system used by the workbook. Mike is wondering how he can display the negative time difference properly? If he subtracts 6:33 from 6:21 he noticed that he doesn't get a negative elapsed time, as in -:12. Mike has a worksheet that contains some times.
