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.

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

=SUMPRODUCT((A1:A50TODAY()-28)*(B1:B50))

Hope this helps


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=391217

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 .

Regards
Bren.


"Alex Delamain" wrote:


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

=SUMPRODUCT((A1:A50TODAY()-28)*(B1:B50))

Hope this helps


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=391217