If the IPO is not alloted can we get a refund? if yes how much time does it take to refund in our bank account?

unalloted ipo always refunded. just wait a few days

The money is never really taken out of your account until the IPO is alloted to you. It’s removed from your available balance i.e. the money is held. So,if you aren’t alloted, the money returns to your available balance within 2-3 days.