Forum Discussion
Excel Work Schedule Planner
Hello,
I have been trying to create a sample schedule for myself that has all the information like how many hours an individual worked in a week, total number of hours all the employees worked in one day but can't find the formula to get those numbers.
Plz help me figure out the formula for this:
EXCEL SETUP:
THANK YOU!
In Q4:
=SUM(MOD(INDEX(C4:P4,{1,3,5,7,9,11,13})-INDEX(B4:O4,{1,3,5,7,9,11,13}),1))
If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
Apply the custom number format [h]:mm to Q4, so that it can display times longer than 24 hours.
Fill down to Q7.
In B8:
=SUM(MOD(C4:C7-B4:B7,1))
If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
Apply the custom number format [h]:mm to B8, so that it can display times longer than 24 hours.
Copy to D8, F8, etc.
