Forum Discussion
How to Calculate Total Hours Worked
Attached is one example of how that might be accomplished. The SUMIFS function is the workhorse here. I'll assume that your version of Excel supports it. The function supports two or more selection criteria per usage; I needed only two criteria in each usage here.
The Log1 worksheet is the log of employee work. The Summary1 worksheet is what a manager might more likely view. I used the custom format [h]:mm;@ for elapsed times and total times, assuming that you are not measuring those values to the second.
Fancier formulas could accomplish this without the need to reserve a column for the Week. But the Week column does not need to be visible for this to work.
I added conditional formatting to highlight the switch between consecutive days. Multiple formatting rules could instead be used to assign specific colors to different days of the week.
This implementation does not use an Excel table, which might be a good alternative, particularly if you're going to keep a very long log of employee work (before switching to another worksheet or workbook).
Attached is one example of how that might be accomplished. The SUMIFS function is the workhorse here. I'll assume that your version of Excel supports it. The function supports two or more selection criteria per usage; I needed only two criteria in each usage here.
The Log1 worksheet is the log of employee work. The Summary1 worksheet is what a manager might more likely view. I used the custom format [h]:mm;@ for elapsed times and total times, assuming that you are not measuring those values to the second.
Fancier formulas could accomplish this without the need to reserve a column for the Week. But the Week column does not need to be visible for this to work.
I added conditional formatting to highlight the switch between consecutive days. Multiple formatting rules could instead be used to assign specific colors to different days of the week.
This implementation does not use an Excel table, which might be a good alternative, particularly if you're going to keep a very long log of employee work (before switching to another worksheet or workbook).
