Thanks so much. I appreciate the link. It will be every helpful. BTW, This
is the first time I've ever used a "Discussion Group." I think I'll use more
often when I have problems like this. Again thanks for the help.

"Peo Sjoblom" wrote:

See:

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


Regards,

Peo Sjoblom


"Michele" wrote:

I am trying to design a simple excel spreadsheet that will calculate overtime
worked. I want it to display similar to this. The spreadsheet would
hopefully be a template and password protected, so all one would have to do
is fill in the blanks.

Sunday 13:30 17:30 4
Monday 17:00 18:00 1
Tuesday 17:00 17:30 .5
etc
TOTAL 5.5

Any suggestions, as I am stymied on how to do this. I am using Excel 2003.
Thanks.