I need someone to create an excel formula/set of formulas/worksheet to calculated staff hours from an excel spreadsheet (attached)
The sheet provides the clock in and out time for each staff member on each day of the week and I need a formula that will calculate the total hours worked per month for each staff member from the above data.
The sheet attempts to calculate the total hours on page 1 'summary' but this number isn't correct.
Modern Rose Water Label Design Category: Adobe Illustrator, Brochure Design, Creative Design, Graphic Design, Label Design, Logo Design, Photoshop, Product Design Budget: ₹600 - ₹1500 INR
10-Dec-2025 17:02 GMT
Versatile Video Editing Project Category: Adobe Premiere Pro, After Effects, DaVinci Resolve, Final Cut Pro, Motion Graphics, Video Editing, Video Production, Video Services Budget: ₹100 - ₹400 INR
Business Management Software Development Category: Agile Development, API Development, Business Management, Cloud Computing, Database Development, Documentation, Project Management, Software Development Budget: ₹12500 - ₹37500 INR
10-Dec-2025 17:01 GMT
Enhance Squarespace Business Website Category: Branding, CSS, HTML, Squarespace, UI / User Interface, Visual Design, Web Design, Web Development, Website Optimization Budget: $250 - $750 USD
10-Dec-2025 17:01 GMT
N8N Sales Data Integration Category: API Integration, Automation, Copy Typing, Data Entry, Data Integration, Google Sheets, JavaScript, N8n, Node.js, REST API Budget: ₹600 - ₹1500 INR
10-Dec-2025 17:01 GMT
VC-Focused Market Entry Pitch Deck Category: Business Analysis, Data Visualization, Google Slides, Graphic Design, Market Analysis, Market Research, Marketing, Powerpoint Budget: ₹12500 - ₹37500 INR
