Creating numbers sheet for timesheet and income
Hello, I am looking to create a timesheet with income in numbers. I have started with the ”employee schedule” template that is provided in the numbers app. But I would like to make a few modifications to what is there, but I don’t really know how to go about doing it…maybe with my screenshot I can convey what it is that I hope to achieve…so here goes.
First off I am the only employee and I am personally keeping up with this for my own records.
Box 1: This table is almost perfect the way it is. But this would just be the box that I would input the dates and times that I am working.
Box 2: Again this box is sorta the way I need it, but the adjustments to this may be what makes or breaks what I am trying to do. I would like for this box to reference the weeks in the year(so by the end of an entire year it would have 52 lines(Week 1-52) then have a total for the week(the way it currently is set up, it references Box 1 as if it were only made for 1 week at a time, and I don’t want to make 52 of these numbers spreadsheets per year.)
Box 3: Don’t necessarily need the graph but would like to have something that shows my year to date income. I don't make overtime so it doesn't need to be fancy and show different colors for each pay type.
I am aware that what I am asking for might not be possible but it is worth a shot to ask. If it cant be done with this particular template maybe someone has created something more like what I need, and can be pointed in that direction?
Thanks to anyone that might be willing to help out on this project!
iPad Pro, iPadOS 18