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

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 [email protected].

Regards
Bren.


"Alex Delamain" wrote:

>
> Try the following:
> Col A is dates
> Col B is hours worked that day
>
> =SUMPRODUCT((A1:A50>TODAY()-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
>
>

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.

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 [email protected].

Regards
Bren.


"Alex Delamain" wrote:

>
> Try the following:
> Col A is dates
> Col B is hours worked that day
>
> =SUMPRODUCT((A1:A50>TODAY()-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
>
>