I used to with software called awaken but I stopped ever since my macbook's fan started to spin all the time... I love silence when sleeping and fan noises go against that
Awaken is great, it gets me up every morning. You can put your Macbook to sleep and Awaken will wake it up, so you can have it turned off during the night. You can get it at http://www.embraceware.com/products/awaken/