How can I transform my data in to daily data instead of a date range?

Occasional Visitor

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: 

statusstart datestart timestop datestop time
test1/1/2208001/4/221500

I need to transform the data from ^^ to vv

statusstart datestart timestop datestop time
test1/1/2208001/1/222400
test1/2/2201/2/222400
test1/3/2201/3/22

2400

test1/4/2201/4/221500

 

Please let me know if you can help! I would be forever grateful!

 

- Mary

1 Reply

@mcamp1225 

 

A Power Query option is attached...