Calculate time

Hi,

I'm trying to find a formula to calculate the time between delivery created time and post goods issue time . pls see attached filesheet


wave time time PGI
1 3:30 7:30 10:15
2 7:30 9:30 12:15
3 9:30 11:30 14:15
4 11:30 13:30 16:15
5 13:30 15:30 18:15

delivery order created between 3:30 to 07:30 is wave 1 as above table , the targeted time for shipping out (PGI) is 10:15 for wave 1 and 12:15 for wave 2 . pls help to calculated which all deliveries have failed and passed .


Thanks for help on this.

Rgds