I have been working on a Google Sheet that I am able to import my Google Calendar into and it automatically breaks it down.
I have one more formula to figure out before its usable but I can't seem to figure it out.
The formula needs to sum up the hours worked by each employee based on the specified dates in the formula. I'd like to break it down Monthly and Weekly.
I have tried the following formula which sums all of the hours worked within the date range:
=SUMIFS('2. Calendar'!G14:G1000,'2. Calendar'!B14:B1000,">="&date(2021,1,1),'2. Calendar'!B14:B1000,"<="&date(2021,1,31))
It needs to also search through a column of names and only show the hours worked for the specified employee. Using this formula below, I'm able to sum up the total hours of a specific employee:
=SUMIF('2. Calendar'!E14:E1000,"*"&D6&"*",'2. Calendar'!G14:G1000)
How can I combine these formulas so that it sums up the total hours worked within a specified date range, by employee?
Any help is appreciated, I have been trying to figure this out now for over a week. I'm at a complete halt until I can find help from someone.
The spreadsheet can be accessed here: https://docs.google.com/spreadsheets/d/1TeB73zsRo3Bm9tvN392Uy1I-KcWy5PRTs6KSFe-m0VM/edit?usp=sharing