tkaplan
01-14-2008, 12:38 PM
hello all,
columns a stores the start time, column b stores the end time. i would like column c to show the difference between the times. there are no dates in any of the columns and i am running into negative time issues because column b is sometimes after midnight and column a is before. what would be the correct formula to put in column c ?
thanks in advance!
columns a stores the start time, column b stores the end time. i would like column c to show the difference between the times. there are no dates in any of the columns and i am running into negative time issues because column b is sometimes after midnight and column a is before. what would be the correct formula to put in column c ?
thanks in advance!