See www.cpearson.com/excel/overtime.htm for examples and a
downloadable workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"john327" wrote in message
...
I would like to set up a table in excel that allows me to enter,
for example:
A time punched in (8:00 AM), time punched out (12:00 Noon) (for
lunch) a time
punched back in (1:00 PM), a time punched out (5:00 PM).
I would like a final cell to calculate total work hours as
8 hours
worked for the day.