If you are talking about the average work week rush hour commute, then you're looking at about 1 to 1-1/2 hours each way. Public transportation from Alpharetta not great. You can catch a bus here that will take you to the Marta train station at North Springs which is in the Dunwoody/Sandy Springs area. I usually suggest my clients live closer in if their commute is to downtown. If you are wanting the Alpharetta schools, there are some locations in Alpharetta that are much closer in than others.
Hope this helps! Let me know if I can assist you further.
"A Reputation for Results"
Stages Realty of Georgia
12600 Deerfield Parkway, Sutie 100
Alpharetta, Georgia 30004