I am posting this under a new thread because I desperately need to find a solution. Nothing suggested has worked yet for all rows and columns. Please see the attached workbook with two different sheets (same data) using different formulas. Each has problems (red text) preventing me from moving forward.
I need to calculate time in level 1, time in level 2 and total time for each row and then be able to sum for the month. Unfortunately, sometimes there is missing data, but I still need to calculate everything possible using a consistent formula that can be applied to the column/row universally.
I am open to any feedback. Many, many thanks in advance!