Creating an Employee Schedule with Numbers

[Alon1]

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!

 

[IGregory]

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!

Did you Google employee scheduling software? The must be a million options available.

 

[Alon1]

I'm sure there are but my friend wants to use Numbers (if possible). In her old job they used Excel for that so she figured Numbers would support it too, which would make for a more streamlined system.

 

[TheralSadurns]

I'll make a quick one for you... to point you in the right direction...sec

 

[simonsi]

Google "excel employee schedule calculator"

Take your pick of the free excel template sites....see how the logic works then replicate in Numbers if it will...

 

[TheralSadurns]

Here. Sadly it is in German (time format etc.) Although... depening on your region setting... maybe not.

 

[TheralSadurns]

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:

 

[Alon1]

Thank you very much guys! I appreciate it

 

[TheralSadurns]

Thank you very much guys! I appreciate it

Is what I did similar to what you intended? Or did I miss your point?

 

[Alon1]

Is what I did similar to what you intended? Or did I miss your point?

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!

 

[TheralSadurns]

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

 

[Alon1]

Do that... because here you didn't attach anything

Haha oops forgot to hit upload. Here it is

 

[TheralSadurns]

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.

 

[Alon1]

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.

Thats perfect! Thank you so much for your help!

 

[TheralSadurns]

You're welcome

 

[lisamarie1]

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.

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