Grouping by date

[Bob McHale]

Hi,
I have a spreadsheet that lists by day the number of hours overtime
employees are paid each day for a 4 month period
01/01/04 02:00
01/02/04 01:00
01/09/04 04:00
01/14/04 05:00
Etc.
I would like to group these by work week so i can total the number of
hours worked in each week. The work week starts on Sun and ends on
Sat.

Thank you in advance for your assistance

 

[Frank Kabel]

Hi Bob
one way:
- add a helper column with the formula
=WEEKNUM(A1)
if column A stores your dates. Copy this down for all rows

Noy you may use 'Data - Subtotals' for creating subtotals for each
weeknumber. You may also format the time column with the custom format:
[hh]:mm
to prevent the rollover after 24 hours in the sum