Workflow · People · Opening soon
Timesheet hours by project
Turn Harvest time entries into a timesheet report. See total hours by project, person and week, split into billable and non-billable.
Someone typed
“total timesheet hours by project, person and week, split into billable and non-billable”
The agent read it as
Total timesheet hours by project, person and week, split into billable and non-billable, from Harvest time entries.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Harvest time entries
CSV export · 28 rows
Step
Total hours by week
Step 1
Result
Weekly Project Hours
22 rows
Schedule
Runs when you say
Proposed
- FileHarvest time entriesCSV export · 28 rows
- StepTotal hours by weekStep 1
- ResultWeekly Project Hours22 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 22 rows came out.
- Download Harvest time entries sample (28 rows)Harvest: Time > Time Entries > Export CSV
What you get back
The result of that run, the rows to look at first.
Weekly Project HoursSample data22 rows
| Project | Person | Week | Billable hours | Non-billable hours |
|---|---|---|---|---|
| Brand Portal | Jonas Reed | 2026-11-02 | 8.50 | 0 |
| Brand Portal | Mina Patel | 2026-11-02 | 2.75 | 1.50 |
| Brand Portal | Owen Brooks | 2026-09-28 | 7 | 0 |
| Client Portal | Ava Chen | 2026-11-09 | 3 | 2 |
| Client Portal | Owen Brooks | 2026-11-09 | 10 | 0 |
| Compliance Pack | Luca Martin | 2026-10-26 | 0 | 2.25 |
| Compliance Pack | Luca Martin | 2026-11-02 | 0 | 2.25 |
| Compliance Pack | Mina Patel | 2026-10-12 | 3.50 | 0 |
| Compliance Pack | Mina Patel | 2026-10-26 | 3.50 | 0 |
| Data Warehouse | Luca Martin | 2026-11-02 | 8.25 | 0 |
| Data Warehouse | Priya Nair | 2026-10-26 | 3.25 | 0 |
| Data Warehouse | Priya Nair | 2026-11-02 | 0 | 1.25 |
How do you total timesheet hours by project, person and week?
Export your time entries from Harvest and upload the file. Mammoth groups the rows by project, person and week, then splits the totals into billable and non-billable hours. It gives you weekly project hours from the exported data.
How it works
How to use the Weekly Project Hours workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Weekly Project Hours: questions
Which export should you use?
Use the time entries export from Harvest. It needs the row-level entries, with the project, person, date and billable fields.
What happens to rows that do not match the rules?
Rows that do not fit the grouping or filters are left out of the result. You can review the source file and adjust the rules if you want them included.
How do you change the grouping or split in words?
Edit the rule text to say what you want grouped, such as by project, person and week, and how to split totals, such as billable and non-billable. Then run the workflow again on the same exported file.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent