Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how many times a particular day of the week appears in a given month | Excel Discussion (Misc queries) | |||
Date Command to Get the Sunday Before the First of the Month | Excel Worksheet Functions | |||
How do I calculate an employee timesheet in Excel? | Excel Worksheet Functions | |||
Need to calulate a sum for once a month X #days X #times used per. | Excel Worksheet Functions | |||
Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) |