Here's something I've been working on for the past few days. Using UDK's Material Editor, Kismet, and Matinee, I was able to put together a beautiful Day/Night Cycle for my Advance Game Project - Rhea.
This system can be implemented to any time frame (currently it is 30 seconds per cycle) and can be designed for time specific events and encounters. It'll be awesome in game!