Forum Discussion
Solved
time sheet by week
iv made a time sheet by month, but now I need to break it down into weeks over the year (52 weeks) week by week instead of month by month as iv done, I have hi lighted in sheet named Sarah what I'm l...
See the SARAH sheet for what I had in mind.
I have yet to work through he changes that prevent a macro-enabled internet file from running on my machine but, since you use 365, it is possible to perform quite complex calculations using spreadsheet formulas alone. What I see for each employee is a list of hours worked by day of the year. To report the hours by week, the first 2 days would need to be stripped off. Then one could wrap the remaining hours to give a 52x7 array
= WRAPROWS(DROP(hoursWorked,2),7,0)The total by week is simply the row sum
= BYROW(WRAPROWS(DROP(hoursWorked,2),7,0), SumĪ»)
where SumĪ»
= LAMBDA(x,SUM(x))