Timesheet Calculate Sunday times that changes every month
 

Hi all the experts

I'm trying to calculate the times worked on a sunday on a timesheet. The
month starts on the 15th and every month the Sunday falls on a different cell
every month. Spreadsheet has the date and days run automatically once the
1st day is captured.

I need to calculate all hrs worked for Sundays if the employee worked on
that day.

please help

Timesheet Calculate Sunday times that changes every month
 

On 12 Mag, 12:04, jeromevw wrote:
Hi all the experts

I'm trying to calculate the times worked on a sunday on a timesheet. The
month starts on the 15th and every month the Sunday falls on a different cell
every month. Spreadsheet has the date and days run automatically once the
1st day is captured.

I need to calculate all hrs worked for Sundays if the employee worked on
that day.

please help

A B C D
Date Hours Sunday hours Tot sunday hours


C2=if(weekday(A2)=1;B2;"")
C3=if(weekday(A3)=1;B3;"")
etc.

D2=sum(C2:C33)

Max

Timesheet Calculate Sunday times that changes every month
 

To keep anyone from thinking I'm clairvoyant or anything - I believe the OP
sent me copy of the workbook with request for help.

The one I received has dates in one column, adjacent column uses WEEKDAY()
to display the day of the week as 3-letter abbreviation as "Sun", "Mon", etc.
Hours worked is in a 3rd column. I recommended using
=SUMIF(B8:B38,"Sun",I8:I38) * 24
where B8:B38 contain the "Sun", "Mon", etc entries and column I has hours
worked on that day.

There is a second area set up on same sheet with same layout, recommended
same same solution with change in column identifiers. Also suggested a
formula to combine both into one 'grand total sunday hours' as
=(SUMIF(B8:B38,"Sun",I8:I38) + SUMIF(L8:L38,"Sun",T8:T38)) * 24


"jeromevw" wrote:

Hi all the experts

I'm trying to calculate the times worked on a sunday on a timesheet. The
month starts on the 15th and every month the Sunday falls on a different cell
every month. Spreadsheet has the date and days run automatically once the
1st day is captured.

I need to calculate all hrs worked for Sundays if the employee worked on
that day.

please help