Multiple Conditions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I want take the start time and end time from column D & E depending on the following conditions :-
1) If we have two shift in column C after one another for same date like we have in row 2 & 3 it should take start time from second row(D3) and end time from next date first row which is E(5) and then it should take duration for those rows and sum them like for date - 3/5/2022 sum of duration should be - F3 + F5 (i.e = 10)
2) If we have two shift in column C after one another for same date but next date is not in sequence like in row C7 we have date - 3/6/2022 and C8 we have 3/11/2022 then it should take start time from second row(D6) an end time from corresponding column (E6) and then it should take duration for those rows and sum them like for date - 3/6/2022 sum of duration should be - F6 (i.e = 5)
3) If we have only shift in first row then break and then shift in third row for same row like we have in row C8, C9, C10 then it should take start time from first row(D8) and end time from last row (E10) and then it should take duration for those rows and sum them like for date - 3/11/2022 sum of duration should be - F8 + F10 (i.e= 6)
Not sure how to do this can anyone help?
I attaching sample file also.
Thank you in advance.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sgaryali ,
this would change the format of how the data is displayed due to different aggregation levels, so can you post the spreadsheet showing the desired outcome?
Thanks,
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
Can anyone help please?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can anyone help please?
