Forum Discussion
Time-Lapse Help
Hello, I am trying to do a time-lapse formula and I get ###### that goes on forever (example below). How do I fix this (the employees don't know or use 24-hour times).
There is a negative time span, AM minus PM.
Excel does not show negative time as standard, and being elapsed time I assume that is not what you want.
It may be visually shown by using a number format (Ctrl+1) like
hh:mm,"Negative not allowed"
Right, when I added up the column, I got a negative number, so how do I fix it to where it is accurate? Or will we just have to do those manually?