Hi, Can anyone point me in the right direction please?
I have a column of data that lists the variance between scheduled time for a task and actual time taken. I need a summary cell that gives the total variance for all cells regardless of whether it was over or below schedule. for example, in the column below, I need a formula that will return 8.29 as the difference between scheduled and actual time over the 6 days:
-0.38
0.61
-2.87
3.45
-0.90
-0.08
thank you!
Bookmarks