How late can the cops show up at your house on an arrest warrant?

If they have a war warrant for your arrest and have due cause to believe that you are in a residence then they can execute that warrant whenever they like. If you believe there is an arrest warrant out for you and you do not want to cause your family distress, go down to the station and give yourself up.