in excel if you subtract time and get a negative you will get the error... ##### "mic can't show negative times"
One way I found to fix this is change to the 1904 date system. Does anyone know of any other ways to do this because the 1904 date system doesn't give the correct DATE calculations. So if anyone has a macro or formula I could use, let me know!
One way I found to fix this is change to the 1904 date system. Does anyone know of any other ways to do this because the 1904 date system doesn't give the correct DATE calculations. So if anyone has a macro or formula I could use, let me know!