Daniel Are you talking about a direct debit? It takes a few business days until the other bank has received your message and sends the money back. Somewhere between 2-4 business days afaik.
Or is your question about a card payment? In that case it can vary individually depending on the merchant.