Need formula to calculate the numbers of hours and get the value true or false

[Giri.hb]

Hi Team,

I have attached the sample file where in the A column I have approved date and time and in the B column I have ordered date and time and I need to get the values (true or false) in C column. Please check and assist.

If the orders are approved before 17:00 and the ordered date shows as same date before 17:00 then the value should come as true.
If the orders are approved before 17:00 and the ordered date shows next date or other dates it should come as false.
If the orders are approved after 17:00 and the ordered date shows next network day date before 16:00 it should give the value as true.
If the orders are approved after 17:00 and the ordered date shows next network day date after 16:00 it should give the value as false.

[JohnTopley]

Try

=IF(AND(INT(A10)=INT(B10),MOD(A10,1)<=TIME(17,0,0)),TRUE,IF(AND(INT(B10)=WORKDAY(INT(A10),1),MOD(B10,1)<=TIME(16,0,0)),TRUE,FALSE))

[Special-K]

Your third condition
If the orders are approved after 17:00 and the ordered date (shouldn't this be approval date?) shows next network day (after what the approved date????) date before 16:00 it should give the value as true.

This gets you the results you have supplied but the logic doesn't look right to me (check your third condition above)
=IF(OR(AND(INT(A2)=INT(B2),TEXT(B2,"hh:mm")<"17:00"),AND(TEXT(A2,"hh:mm")>"17:00",INT(B2)=WORKDAY(A2,1),TEXT(B2,"hh:mm")<"16:00")),TRUE,FALSE)

[Special-K]

Try

=IF(AND(INT(A2)=INT(B2),MOD(A2,1)<=TIME(17,0,0)),TRUE,IF(AND(INT(B2)=INT(A2)+1,MOD(B2,1)<=TIME(16,0,0)),TRUE,FALSE))

John, I'm getting TRUE for 04/08 and 29/07 Approval dates, rows 4 and 8 with your formula

[Bo_Ry]

Please try at D2

=B2<IF(MOD(A2*24,24)<17,INT(A2)+17/24,WORKDAY(A2,1)+16/24)

[josephteh]

Another formula:
=OR(AND(MOD(A2,1)<17/24,INT(B2)=INT(A2)),AND(MOD(A2,1)>=17/24,B2<WORKDAY(A2,1)+16/24))