View Single Post
  #1   Report Post  
Bren
 
Posts: n/a
Default Creat a formula to calculate working hrs according to number of da

How do I write a formula to sum the number of working hours according to pass
28 days. That is, based on the last 28 days, how many hours have I worked
(,considering that I do not work everyday).

For example, what I have in the excel worksheet:
Column A - dates
Colume B - working hours

Any advise would be appreciated.

Thanks.