Hi! A friend of mine asked me this question: How do you (and can you?) create a schedule using numbers that will calculate the number of hours in a workweek per employee? In other words, let's say the schedule says I work on Mondays 9am to 3 pm and the rest of the week I'm off, the schedule is going to show the days and times I work and one "total hours" column which in this case will say " 6 ". I googled it and searched the archives here but no luck. Thanks in advance!
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Creating an Employee Schedule with Numbers
- Thread starter Alon1
- Start date
- Sort by reaction score
Did you Google employee scheduling software? The must be a million options available.
Here. Sadly it is in German (time format etc.) Although... depening on your region setting... maybe not.
Or... if you think more in time slots... and wanna make sure every time slot is occupied by a certain amount of people... you could approach it like this:
It's very close. I think she can either use yours or get an idea of how it works and implement it in hers. I am attaching a mockup I made of what she had in mind, please let me know if you have any tips, ideas, notes, etc.
Again, I really appreciate your help!
Do that... because here you didn't attach anything
Haha oops forgot to hit upload. Here it is
If you want it like this... you can do it... like this:
(My computer is set to 24h clock... just disregard this.)
Also... you have to have separate cells for start and end time. It MIGHT be possible to do it in one cell... but I have no idea how... and like it is, it shouldn't be bothersome either.
(My computer is set to 24h clock... just disregard this.)
Also... you have to have separate cells for start and end time. It MIGHT be possible to do it in one cell... but I have no idea how... and like it is, it shouldn't be bothersome either.
Hello, sorry hoping you’ll reply back even though this was years ago. I went to use your spreadsheet you’ve shared but I don’t understand it. Please could you help sorry
