The Time Offset and the Send Trigger settings work together to determine when the email should be sent.
A positive time offset value will work with the Send Trigger rule to send the email.
In particular the send trigger "Before Check-in" needs a positive time offset to send before check-in. In this case a negative time offset will send after check-in.