Forum Discussion
Hours Worked in Rolling Period
Hi, this is probably dead easy but I am struggling to figure out how to make a function that generates how many total hours someone has worked in a 7-day and 28-day "rolling" period. i.e. On day 3 (...
As variant that could be
=SUM(OFFSET(C2,0,0,-MIN(ROW()-ROW($C$1),7)))
and
=SUM(OFFSET(C2,0,0,-MIN(ROW()-ROW($C$1),28)))
Attached
That's very nice.
