Forum Discussion
Time Differences Negative and Positive
Hi, I am wondering if there is a way to change negative numbers in Excel to positive numbers, but also keep the already positive numbers that are there. I am calculating the time between an...
Not sure what you mean that the line above is a different date. Can you put in a check that current line and previous line have the same date before you do your calculation?
Generally , I would recommend using the Excel time functions (e.g. timevalue) for calculating time differences.
Not sure if that helps you?
Peter