Jul 09 2019 05:23 AM
Jul 09 2019 05:23 AM
Activity # Total Time (yesterday) Time spent (today)
1 4 2
2 0 4
3 3 5
4 2 0
I have a data similar to the one shown above. I want to update my total time for every activity based on the time spent (today). Initially I want to set the value of all the cells in Total Time to zero and then update it based on my data from today . So I want to write a formula that adds the time spent from today to current value of Total time from yesterday for every activity. i.e
Total time (today) = Total Time (yesterday) + time spent (today)
OR
x (current value) = x(initial value) + constant
In other words I want to have a way to save the total time values from yesterday. With for Loop it is possible but I can not use VBA or Macros as I am working at excel online.
Regards,
Tayyab
Jul 09 2019 05:30 AM
@Deleted
Afraid that doesn't work in Excel Online since you have circular reference
Jul 09 2019 05:45 AM
Is there a way to develop a For Loop in excel using default available formulas (without VBA code) ?
Jul 09 2019 07:38 AM
@Deleted
To my knowledge - no