See Chip Pearson's site.

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


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 11:54:58 -0700, puzzled
wrote:

I am trying to design a template to do timesheets with. How do I create a
formula that will read in time, out time, lunch time then total for the week?
(8:00am-12:00 then 1:00-5:00 = 8 hours?