|Week | Actual Time | Planned Time|
|— | — | —|
|1 | 2 | 5|
|2 | 6 | 5|
|3 | 3 | 5|
|4 | | 5|
|5 | | 5|
|6 | | 5|
What I’d like it to do is give me the total of the planned time but if an actual time is given - override the planned time.
For example, if no actual time was entered the “planned time” = 30 (5+5+5+5+5). But if 3 weeks have passed and have actual time reported then I want the actual time to replace the planned time for that week - so my formula would automatically change to (2+6+3+5+5+5). If I changed the actual time in week one from 2 hours to 8 hours, my formula would then be (8+6+3+5+5+5).
And the Sum would probably display on a different summary table broken down by person.