Oct 03 2022 05:03 PM
Each row of my data signifies the time a job entered a certain status until it left that status. It is tracked by start date & time to end date and time. I need to make this data daily data.
Ie:
status | start date | start time | stop date | stop time |
test | 1/1/22 | 0800 | 1/4/22 | 1500 |
I need to transform the data from ^^ to vv
status | start date | start time | stop date | stop time |
test | 1/1/22 | 0800 | 1/1/22 | 2400 |
test | 1/2/22 | 0 | 1/2/22 | 2400 |
test | 1/3/22 | 0 | 1/3/22 | 2400 |
test | 1/4/22 | 0 | 1/4/22 | 1500 |
Please let me know if you can help! I would be forever grateful!
- Mary
Oct 03 2022 11:31 PM