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