Trying to build an hours worked tracker, 'cos I tend to forget when I do overtime to book it.
Anyway I've gone all OTT and have an overview page that breaks down hours worked per month, both standard and overtime, and tracks for the year.
I have been populating the table by hand so I would have to change the sum() formula for each month whenever I add a new shift. Is there A way to use the month() function inside a sumif()? I just cant figure it out.
My data sheet is laid out:
A B C D E F
Date Shift Start Shift End Hours Worked Rate Total
Right now the table is literlary:
But if I can get that bit to autocalulate, I needent worry about order, and be able to filter/sort to my hearts content.
I tried the below, no no joy:
Any ideas?
Anyway I've gone all OTT and have an overview page that breaks down hours worked per month, both standard and overtime, and tracks for the year.
I have been populating the table by hand so I would have to change the sum() formula for each month whenever I add a new shift. Is there A way to use the month() function inside a sumif()? I just cant figure it out.
My data sheet is laid out:
A B C D E F
Date Shift Start Shift End Hours Worked Rate Total
Right now the table is literlary:
Code:
January =sum(=SUM(Data!D2:D32)
Febuary =SUM(Data!D33:D61)But if I can get that bit to autocalulate, I needent worry about order, and be able to filter/sort to my hearts content.
I tried the below, no no joy:
Code:
=SUMIF(A:A, MONTH(A:A)=1,D:D)Any ideas?
Last edited: