Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
AFUSA said:
Need formula to interpret timestamp's from Form, by month, year and by day,month,yearI 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
No comments:
Post a Comment