How to calculate hours, week by week...

Hi
i m trying to use the formula sumifs but i m not been able to make it work...

i need to sum all hours on every week....

Date Hours Weeks Total
01/03/2014 12:00 08/03/2014 36:00
02/03/2014 12:00 15/03/2014
03/03/2014 12:00
06/03/2014 12:00

thank you
Albano

Hi Albano,

See if this works. Note that the week dates I have assumed are the last day of the week (so 15/3/14 will count the week of 9/3/14-15/3/14)

An example of non Array formula.D2 is end date of required week.

Please Login or Register  to view this content.

hi!!
thank you very much it s working.
cheers
Albano

Hi Albano,

If this has solved your problem, please mark the thread as [SOLVED]