Creat a formula to calculate working hrs according to number of da

G

Guest

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.
 
A

Alex Delamain

Try the following:
Col A is dates
Col B is hours worked that day

=SUMPRODUCT((A1:A50>TODAY()-28)*(B1:B50))

Hope this helps
 
G

Guest

Hi Alex,

Thank you for your help.

I have applied the formula but the hours came out zero. If you don't mind,
I would like to send over my spreadsheet for your review. If its ok with
you, please advise your email address by sending it to (e-mail address removed).

Regards
Bren.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top