Your data structure is not friendly for this. There are two major issues

1) You have data going across
2) You have text "hrs" in each data cell and this will not naturally
calculate or group.

I would start by re-arranging the data and setting it out with a start and
an end time and then calculate in Excel the total, e.g. columns as
follows...

Date Name In Out Total

and data like this in the columns, running down the rows with each entry.

01/01/2008 Nick Hodge 08:00 17:00 9:00

You may need to take account of lunch etc, so just make them another column.
You can then summarise using excel functions, Pivot tables, etc.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Jrufin" wrote in message
...
Hi,
Hope can anyone please help me on this predicament:

I have a raw data table showing Names versus Hours Worked as shown

Name Jan 1, Jan 2, Jan 3, Jan 4, Jan 5 €¦.
Bob 10hrs, 8hrs, 2hrs, 0hr, 1hr
Steve 8hrs, 8hrs, 8hrs, 2hrs, 2hrs
John 6hrs, 5hrs, 3hrs, 1hr, 0hr


The dates are from Jan 1 to Dec 31 (whole year) so I just cut it for
illustration purposes. My question is how to easily create a table to
group
the work summaries as per the dates I want (actually based on our company
fiscal calendar range dates) or as per the date range I want€¦...

The final table should be looking like this:
Name Jan 1 ~ 15, Jan 16 ~ 20, Jan 21 ~ 30,etc
Bob ?? Hrs, ?? Hrs, ?? Hrs,
Steve ?? Hrs, ?? Hrs, ?? Hrs,
John ?? Hrs, ?? Hrs, ?? Hrs,


The date range can vary as per user's requirement, say they want work
summaries every 3 wks, forthnightly, etc

Please help! Thanks!