Support Questions
Find answers, ask questions, and share your expertise

split hourly data based on start and end time

Highlighted

split hourly data based on start and end time

New Contributor

Hi I need to have an   hourly status data  each patients based on their start and end time . here discharge order to discharge date time

For example in the screen shot below, I would like to have hourly row  in between disc_orderdt and discharge_date time

for first row patient i want is : each date should have  24 hours (0 to 23)

calendar date   hour   status 

2020/07/18       0          n/a

2020/07/18        1         n/a

2020/07/18       18        waiting

2020/07/18       19        waiting

2020/07/18        20       discharged

2020/07/18        21       n/a

2020/0718         23       n/a

 now second row....

.

.

chuiee_0-1600797004471.png

 Please advise

Thank you

 

Don't have an account?