Hours worked onsite for Entire Project
I have a project that is setup in a worksheet, and each site has its own folder and project plan.
I am wanting to have the days calculated that have been worked, or passed, but only "onsite" parts of my project plan, not the office clerical side.
I then want to turn that to hours worked.
I then need it to go back to a central location, to log total hours worked on this project for a health and safety dashboard.
I am thinking I will need to identify each row that is considered "onsite" work, and then use a if today() then type statement to see if today has passed or not, and get a total at the bottom of the sheet. then multiply that by the hours of a typical day, I know it will not be exact but that is the best idea I currently have.
Am I on the right track above?
How would I get that to go back to the main project tracker, and when I make new folders for the next new project?
Thank you in advance for the help.
Answers
-
Hi @Jon L
Do you already have a column in your sheet that calculates the number of working days each row took to complete?
If so, you could use a SUMIFS function to add together all the days worked IF the row has a marker indicating it was Onsite and IF the End Date is in the past. Then you can multiply it by 8 (or however many hours you have in a working day).
For example:
=SUMIFS([Days Column]:[Days Column], [Work Location]:[Work Location], "Onsite", [End Date]:[End Date], < TODAY()) * 8
Depending on your plan type, you could put this in a Sheet Summary field or use a cross-sheet formula in a separate sheet:
=SUMIFS({Column with Days}, {Work Location Column}, "Onsite", {End Date Column}, < TODAY()) * 8
Let me know if this helped! If not, it would be useful to see a screen capture, but please block out sensitive data.
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives