See if link helps

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

VBA Noob