software

Hello,

The first chart below shows dates and clock in time and clock out times
(formatted as time).

Production In Production Out
December 09, 20056:00:00 PM9:00:00 PM
December 10, 20051:00:00 PM6:00:00 PM
December 11, 20051:00:00 PM5:00:00 PM
December 12, 2005
December 13, 2005
December 14, 2005
December 15, 2005
December 16, 20056:00:00 PM9:00:00 PM
December 17, 20051:00:00 PM6:00:00 PM
December 18, 20051:00:00 PM5:00:00 PM
December 19, 2005
December 20, 2005
December 21, 2005
December 22, 2005
December 23, 20056:00:00 PM8:00:00 PM
December 24, 200512:00:00 PM3:00:00 PM
December 25, 2005

The next chart below shows where I would like the total hours to appear.
However the chart below shows week ending dates. I need a formula that will
calculate not only the date in the first column but also the previous 6 days
(before the date).

Note: The week ending date does change week to week so the formula would
need to reference a cell number, not a specific date.

Total
Production
Hour
December 25, 2005
December 18, 2005
December 11, 2005
December 04, 2005
November 27, 2005

Thanks for the help.
Jim,
I replied to your previous post a half hour ago. Please see if it
helps.

Kostis Vezerides