Forum Discussion
enushjbiju
Oct 05, 2021Copper Contributor
Windows Update page in Settings keeps loading
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).
1 Reply
Sort By
- enushjbijuCopper Contributor
I found the solution. Follow the steps.
1) Open CMD as administrator.
2) Copy the following:
net stop wuauserv net stop bits
3) Go to "C:\Windows\SoftwareDistribution" and delete all folders and files in it.
4) Open CMD as administrator.
5) Copy the following:
net start wuauserv net start bits
6) Finally restart your PC.