Hi there! I am a nanny for 3 different families at once. Each family pays me a different rate depending on the combination of children. For example, when Family A's child is the only child in my care, they pay me $10/hour. When I have Family A and B's children, A pays me $5/hour and B pays me $7. When I have A, B, and C's children, family A pays me $4/hour, B is $6/hour, and C is $5/hour. When I have Family A and C, A pays me $6 and C pays me $6. So there's a lot of numbers floating around, and I am a very novice Excel user. I'm trying to figure out if there is a way to have a template set up where I can just plug in my hours every week and the spreadsheet will do all the math for me?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Nanny Share Timesheet
- Thread starter EmmaK
- Start date
-
- Tags
- multiple rates timesheet
