i wish to have the output arrange this way appreciate
ID | Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
PR06278 | ABCD | 2024-05-03 | 09:09:21 PM | 00:00:00 |
Based on this dataset. Appreciate the help!
Time Tracking | ||||||
PR06278 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | 2024-05-03 | 09:09:21 PM | ||||
Total | 00:00:00 | |||||
PR05306 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | ABCD | 2024-04-29 | 2024-04-29 | 05:22:45 PM | 10:33:13 PM | 05:10:28 |
Total | 05:10:28 | |||||
PR05837 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | ABCD | 2024-04-29 | 2024-05-01 | 05:20:25 PM | 01:04:30 AM | 31:44:05 |
Total | 31:44:05 | |||||
PR121271 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | 2024-05-03 | 11:15:56 PM | ||||
Total | 00:00:00 | |||||
PR06024 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | ABCD | 2024-05-06 | 2024-05-08 | 09:20:57 PM | 02:23:48 AM | 29:02:51 |
ABCD | ABCD | 2024-04-23 | 2024-04-23 | 12:38:10 AM | 12:38:15 AM | 00:00:05 |
Total | 29:02:56 | |||||
PR05326 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | ABCD | 2024-05-07 | 2024-05-07 | 03:54:57 AM | 09:54:15 PM | 17:59:18 |
ABCD | ABCD | 2024-05-06 | 2024-05-06 | 09:16:25 PM | 09:50:53 PM | 00:34:28 |
Total | 18:33:46 | |||||
PR05327 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | ABCD | 2024-05-07 | 2024-05-08 | 09:54:39 PM | 01:57:11 AM | 04:02:32 |
Total | 04:02:32 | |||||
PR06375 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | ABCD | 2024-04-29 | 2024-05-06 | 05:21:44 PM | 11:58:17 PM | 174:36:33 |
Total | 174:36:33 | |||||
PR06025 | ||||||
Started By | Ended By | Start Date | End Date | Start Time | End Time | Duration |
ABCD | 2024-05-08 | 02:49:24 AM | ||||
Total | 00:00:00 |
Solved! Go to Solution.
Hey @Cherub7210,
Here's a solution for you in with only a few tools, just involves some data cleaning!
Cheers,
thank you for the solution Brando, is there a way we include the ID?
thank you for the solution, is there a way we attach the item to the column outputs?
@Cherub7210 you bet, apologies for missing it on the first go around!
Adding the ID might be a touch more challenging but it's certainly possible to accomplish. I'm taking a look!
Thank you this works!
Can i also ask if i use multiple sheets of excel to go through the same process, should i utilize a macro? and how should i configure that?
You'd want to use a batch macro. Take a look at this macro
And then look at this flow chart.
https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
thank you so much