If formula with date plus one.

[welndmn]

Hello Everyone,

I'm struggling with a formula and dates
Here is the table

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Time[/TD]
[/TR]
[TR]
[TD]10/02/2018
[/TD]
[TD]08:00am[/TD]
[/TR]
[TR]
[TD]10/02/2018[/TD]
[TD]04:00pm[/TD]
[/TR]
</tbody>[/TABLE]

What I am trying to do is if Time in B2 is greater than 15:00 then date should be A2 date +1 day
If Less than 14:59, then use the date in A2.

 

[Grand]

Hej,
See if this formula can help you:

=IF(B2>TIME(15;0;0);A2+1;A2)

 

[welndmn]

That is perfect, Thanks!