jose_graca
New Member
- Joined
- May 18, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have a time shift table, where 0 means no activity (or day off) and values > 0 are different activities.
I can find the start hour of the first shift and the end hour of the last shift, but i'm struggling to find the last hour of the first shift and the first hour of the second shift.. The table should look like this:
Taking in account the example above, what i exactly want is a formula to determine that:
I can find the start hour of the first shift and the end hour of the last shift, but i'm struggling to find the last hour of the first shift and the first hour of the second shift.. The table should look like this:
Taking in account the example above, what i exactly want is a formula to determine that:
- On row 3, the end of the first shift is column S (or 14:00) and the beginning of the second shift is column V (or 15:30)
- On row 6, the end of the first shift is column U (or 15:00) and the beginning of the second shift is column X (or 16:30), and so on...