Creating an Employee Schedule with Numbers

Discussion in 'Mac Apps and Mac App Store' started by Alon1, Nov 17, 2014.

  1. Alon1 macrumors member

    Joined:
    Sep 10, 2014
    #1
    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!
     
  2. IGregory macrumors 6502a

    IGregory

    Joined:
    Aug 5, 2012
    #2
    Did you Google employee scheduling software? The must be a million options available.
     
  3. Alon1 thread starter macrumors member

    Joined:
    Sep 10, 2014
    #3
    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.
     
  4. TheralSadurns macrumors 6502

    Joined:
    Jul 8, 2010
    #4
    I'll make a quick one for you... to point you in the right direction...sec
     
  5. simonsi macrumors 601

    simonsi

    Joined:
    Jan 3, 2014
    Location:
    Auckland
    #5
    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...
     
  6. TheralSadurns macrumors 6502

    Joined:
    Jul 8, 2010
    #6
    Here. Sadly it is in German (time format etc.) Although... depening on your region setting... maybe not.
     

    Attached Files:

  7. TheralSadurns macrumors 6502

    Joined:
    Jul 8, 2010
    #7
    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:
     

    Attached Files:

  8. Alon1 thread starter macrumors member

    Joined:
    Sep 10, 2014
  9. TheralSadurns macrumors 6502

    Joined:
    Jul 8, 2010
    #9
    Is what I did similar to what you intended? Or did I miss your point?
     
  10. Alon1 thread starter macrumors member

    Joined:
    Sep 10, 2014
    #10
    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!
     
  11. TheralSadurns macrumors 6502

    Joined:
    Jul 8, 2010
    #11
    Do that... because here you didn't attach anything :D
     
  12. Alon1 thread starter macrumors member

    Joined:
    Sep 10, 2014
    #12
    Haha oops forgot to hit upload. Here it is
     

    Attached Files:

  13. TheralSadurns macrumors 6502

    Joined:
    Jul 8, 2010
    #13
    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.
     

    Attached Files:

  14. Alon1 thread starter macrumors member

    Joined:
    Sep 10, 2014
    #14
    Thats perfect! Thank you so much for your help! :)
     

Share This Page