Offsetting a date based on time in excel using if and function

A confusing title, I know!

Let me explain in a little more detail.

A report I run is from 4am as opposed too midnight, so I'd like to offset dates with a time earlier than 04:00 by 1 (to make it a day earlier).

E.g. I run a report for 12/12/18 - I would get from 04:00 12/12/18 to 03:59 13/12/18 - I hope this makes sense.

I've been playing around with an IFAND statement:

=IF(AND(HOUR([@Time])>"00", HOUR([@Time])<"04", [@Time]="pm"), "yes", "no")

I've had little luck - every entry is "no"

Here is some sample data:

Any help would be greatly appreciated