Creating numbers sheet for timesheet and income

What you're asking for is easily done via a Pivot Table.

For your use case with just one employee, it's simple, but the same setup could automatically tabulate multiple employees.

To make it easier, make a couple of changes to your existing Sign In table:

Add a new column C that calculates the Week Number for the date in column B using the formula:

=WEEKNUM(B2, Sunday is 1)

When done, you can hide this column if you don't want to see it, but this gives an easy way of mapping dates to weeks of the year.

Then, add a new column at the end that calculates the pay for that day. Since it's just you, you can simply multiply the Hours column by your pay rate (if you have multiple employees to track you'd use a LOOKUP() to find their pay rate).

Then you should end up with a table that looks like:

From here, select the table and choose Organize -> Create Pivot Table -> On Current Sheet (or on a new sheet if you prefer)

The key thing here is in the Inspector sidebar where you tell Numbers how to categorize the data.

For this setup, drag the Employee entry from the Fields to the Rows box.

Then drag the Week No. field to the Rows box, below the Employee tag.

This tells Numbers how you want to categorize the data - by Employee and Week Number

Then drag the Pay field to the Values.

You should end up with something that looks like:

and your table should look something like:

Done.

If you have multiple employee names, the week numbers will be repeated for each employee.

it may sound like a lot of work, but it's actually pretty simple - I added step-by-step instructions since I'm not sure of your familiarity with the app so I didn't want to make assumptions, at the cost of making it look like more work than it really is :)

As for iPad vs. Mac... I admit I'm biassed towards the Mac version, but the same should be possible in the iPad.

If the Pivot Table steps are what's complicating things, you could also do this via just categorizing the data, but you'd still need to add the WEEKNUM() column to be able to group the shifts by week.

I couldn't find an easier way to describe it, so I created a short video showing how I did it on an iPad. Hopefully that helps.

https://share.icloud.com/photos/026zoeGrOyWuojcI0uO5x4nwg