These links have tips and or examples

http://www.j-walk.com/ss/excel/files/timesht.htm

http://www.cpearson.com/excel/overtime.htm

http://www.vertex42.com/ExcelTemplat...-template.html

VBA Noob