I simply love this application!
You manage your profiles and set specific time of the day to start.
Example no email, text, Facebook etc notification sounds from 10pm until 7am

Cons – no auto change if you have meetings

Profile Manager lets you select from a list of predefined profiles like General,Silent,Meeting etc. and you can edit those profiles for changing the ringtone and notification sounds.It also lets you create auto profiles i.e based on time the profile changes.Users can edit and delete auto profiles.

Latest version: 1.0 (for all Android versions)