Friday, August 26, 2011

yogi_Compute Sum Of Hours By Day, Month, And Year As Specified Year

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
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