how to make old sales considered as new

[mina97]

i have the following data 

date/time	type
19/9/2023 16:10:02	A
20/2/2023 16:10:02	B
20/2/2023 9:00:11	B
20/3/2023 12:22:34	A

i want the orders that comes after duty hours which is 7:00:00 to 15:00:00 to be included with the day after 

so the order number 2 should be summed with the orders on  20/3/2023 because it came on 16:10:02 which is after 15:00:00

please helo and thank you 

[v-xinruzhu-msft]

Hi @mina97 

Can you provide some more information and the expected output you want, i am confused that how to add the order.

Best Regards!

Yolo Zhu