Microsoft Teams Blog articles

Need assistance to correct a formula

The provided spreadsheet formula currently calculates weekly hours only when the date in column B is a Saturday. The user wants to modify the formula to calculate the total hours worked from Monday to Sunday, displaying the result on Sunday's row in column G. The calculation should include all hours from each Monday through the following Sunday. The original formula needs to be adjusted to correctly sum hours within each specified week, starting on Monday and ending that same week on Sunday.
favicon
techcommunity.microsoft.com
techcommunity.microsoft.com
Create attached notes ...