Work Log Entry Form
Add multiple gardening tasks, then calculate totals and cost.
Example Data Table
A sample layout similar to the log rows above.
| Date | Task | Start | End | Break | Travel | Rate |
|---|---|---|---|---|---|---|
| 2026-02-24 | Watering & hose checks | 07:30 | 09:10 | 10m | 0m | ₨ 450.00 |
| 2026-02-24 | Compost turning | 10:00 | 12:20 | 15m | 5m | ₨ 450.00 |
Formula Used
- Work Minutes = minutes(End − Start), with overnight support.
- Net Minutes = max(0, Work Minutes − Break Minutes + Travel Minutes).
- Total Hours = Net Minutes ÷ 60.
- Regular Hours = min(Total Hours, Overtime Threshold).
- Overtime Hours = max(0, Total Hours − Overtime Threshold).
- Row Cost = (Regular Hours × Rate) + (Overtime Hours × Rate × Overtime Multiplier).
How to Use This Calculator
- Enter the worker and project/bed details at the top.
- Set overtime rules (threshold and multiplier) if needed.
- Add one or more work rows using the “Add Row” button.
- Fill each row with date, task, start/end, and breaks.
- Press Calculate to see results above the form.
- Use Download CSV or Download PDF from the results card.