*Yogi Anand, D.Eng, P.E.*Google Spreadsheet

*www.energyefficientbuild.com*

*AFUSA said:*

*Need formula to interpret timestamp's from Form, by month, year and by day,month,year*

*I have a Form that employees submit their time worked each day. The time stamp logs it. I need a formula to add all the hours of this month, from this year, and for this day, this month, this year.*

*Here is what I was using: =ArrayFormula(if(len(J1),SUMIF(month(A2:A),J1,C2:C),iferror(1/0))*

*But next year it will include the months from both years.*

------------------------------------------------------------------

In the following solution I used the Query function to compute the sum of hours for current day, current month and year, and current month all years