Need help on : (Numbers 09)Using template employee schedule and would like use but be able to input a afternoon shift ex; 2pm to 8pm or 11:am to 7:pm template is using in in am and out in pm i need more flexablity the that can anybody help?

Need help on : (Numbers 09)Using template employee schedule and would like use but be able to input as a afternoon shift ex; 2pm to 8pm or 11:am to 7:pm template is using in in am and out in pm i need more flexablity then that, can anybody help with formula to use and or change exsitinting forumal that template is useing thanks?

iMac, Mac OS X (10.7.5)

Posted on Jan 10, 2013 4:51 PM

Reply
15 replies

Jan 10, 2013 6:24 PM in response to Bagger50

Select cell C4 in the main table.

Open the Cells Inspector.

Select the first line in the list.

Press the Minus button at the bottom of the panel to delete the first entry and repeat until all the times are gone, but don't delete the blank entry at the end of the list. Don't be tempted to salvage any of the old times - they must all be deleted or there will be errors in the calculations.


Press the Plus button and add your first In Time, 6:00 am. Repeat for 7:00 am, 1:00 pm and 2:00 pm.


These will be your In Time choices. If there will need to be others, you have to consider another scheme or add them now.


Set C4 to the blank entry and Copy. Paste to the rest of Row 4 cells to the right.

Copy the entire row of times for Monday and Paste to each of the other days' start times.


Follow this same procedure for the Out Times.


At this point you should have an operating spreadsheet. It shouldn't be necessary to change any formulas.


Let me know how it goes.


Jerry

Jan 12, 2013 10:20 AM in response to Bagger50

B50,


You and your wife are quite welcome. That template has been the topic of many discussions here. It took us some time to come to grips with the fact that the times in the Pop-up menus carry with them a Date as well, unseen as it is. That is why when you edit or add one time value, in either the "In" or "Out" times, you must replace them all. The penalty for not doing that is that your shift length can be off by as many days as the difference between the dates of editing the list. (That could mean a lot of overtime calculated)🙂


There are also many oddities in the calculations - they work, but resemble freshman attempts at a homework assignment in a beginning programming class. I reworked all the formulas to a form more to my liking. One of the things I did was change the shift length calculation so that it doesn't matter if the times are edited on different days.


If you ever think of any changes you would like to make to the template, just ask. We may have already talked about it here.


Jerry

Jan 15, 2013 5:08 PM in response to Bagger50

Hi Green1,


B50 here, on the same template that i had talk to you before on the employee schedule is there and easy way to copy/paste or ( ? ) the rolls are columons to add extra lines for more employees by keeping the same formula's and etc. but just having to change the names of said employyee that to a new added one? Thanks for your Help !

Jan 16, 2013 6:28 AM in response to Jerrold Green1

Hi Jerry,


Thanks for the response, I should have told you that I customize this a little making the days of the week at top & names along the side and putting the total of hours at the bottom of each column to the far right in row with the new rows of names. Heer is where I wanted to expand down to add a few more names in the frist row which are meraged cells, I try and addat the handle and all it dose is give me one more cell. I was hoping to create a whole new employee row with name and (in,out,hours) is this possible ? Thanks p.s. I know this will start a new page also. B50

Jan 22, 2013 5:08 PM in response to Jerrold Green1

Hi Jerry,


Wondered if you can help me on this one problem that i'm stuck on ? Template Employee Schedule. The formula here, =IF(OR(I3="",I4=""),"",IFERROR(I4-I3-Administration Information :: $B$1,"")) works. I changed the value or input in the Administration information table from a 1hr lunch to a 30 minute lunch and it works fine employees only are scheduled for a 30 minute break/unpaid. how ever i need to add something to this if possible for a few of the employees that are part time and only scheduled lesser hours with no lunch. Anything that is scheduled over 6.5 hrs then they are intitled to lunch break. Anything less then they get a paid 15 min break is ther a way to include something in the formula for lesser then 6.5 or greater then ? Thanks for any input Bagger50.


Duration of lunch break

0h 30m

Jan 23, 2013 3:54 PM in response to Bagger50

Bagger,


It appears that you have rearranged the table design. I gave you the expression that would be used to customize the deduction for lunch break based on daily hours in the Numbers standard Employee Timesheet template, as shown in my screen shot.


Clearly, that expression will need to be reworked in a table that has been rearranged. I imagine that you can do that yourself, but if you need help, send me a copy of your document.


Jerry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Need help on : (Numbers 09)Using template employee schedule and would like use but be able to input a afternoon shift ex; 2pm to 8pm or 11:am to 7:pm template is using in in am and out in pm i need more flexablity the that can anybody help?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.