It depends if you do it in a open area or closed. If you do it in a a closed environment, it will last a lot longer (ex.your bathroom). If you do it outside it will wear off fast especially if the surface is hot. It inst like instantaneous, it ill take a min or so if its not in the sun. But, be careful were you spray it, I sprayed it on my dads mattress and we had to throw it out because the stink soaked in, or maybe it was because i used a half of bottle on it. lol
Unfortunately it won't last long in large open spaces, if there is air flow it will wear out in minutes. Any small place like a desk, car or small room is best. It should last a few hours and a lot longer in small spaces. Some people can't ever get the smell out of cars
I was outside my friends home talking with him and snuck a spray or two onto the wall, despite it being a windy day it smelled pretty bad, not as much as it lingering indoors but noticable. I woukd not know about soraying it directly into the air. It smells so horrible i wouldn't doubt it.