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?

Question

Level 1

0 points

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

Answer 1

Jan 10, 2013 4:56 PM in response to Bagger50

B50,

Sure, we can help you with that. Can you list for us all the possible start times, and all the possible end times?

Jerry

Reply

Answer 2

Bagger50 Author

Level 1

0 points

Jan 10, 2013 5:04 PM in response to Jerrold Green1

Yes thanks the moring shifts are 6am - 2:30pm , 7am-3:30pm & 10:30 am - 6;30pm now for the afternoon shifts - 1pm - 9pm, & 2pm - 9 pm this will mainly be used. Thank you

Reply

Answer 3

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

Reply

Answer 4

Bagger50 Author

Level 1

0 points

Jan 10, 2013 7:12 PM in response to Jerrold Green1

Thank you I will give this a try tomorrow night after work again Thanks,B50

Reply

Answer 5

Bagger50 Author

Level 1

0 points

Jan 12, 2013 9:45 AM in response to Jerrold Green1

Thanks Green1, for your help on the Employee Schedule the other night it is working great no problems at all and my wife thanks you too, it will make her job a lot easier ! Thanks Again for your Help !

Reply

Answer 6

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

Reply

Answer 7

Bagger50 Author

Level 1

0 points

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 !

Reply

Answer 8

Jan 15, 2013 6:19 PM in response to Bagger50

B50,

Click the Add Columns handle to add one column, or Drag the Add Columns handle to add more than one columns.

To reveal the Add Columns handle, select a cell in the table.

Jerry

Reply

Answer 9

Bagger50 Author

Level 1

0 points

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

Reply

Answer 10

Jan 16, 2013 9:23 AM in response to Bagger50

B50,

You can add rows with the Add Rows Handle in the lower left corner, similarly to adding columns with the Add Columns Handle.

If every body row has identical formulas, top to bottom, a new row added this way will inherit the formulas. If you were not consistent in the formulas, you will have to add them manually.

Jerry

Reply

Answer 11

Bagger50 Author

Level 1

0 points

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

Reply

Answer 12

Jan 22, 2013 7:35 PM in response to Bagger50

I added two constants to the admin table and adjusted the day's hours formula to meet your conditions:

The formula for hours in C6 is now:

=IF(OR(LEN(C4)=1,LEN(C5)=1),"",C5-C4-IF((C5-C4)>Administration Information :: C1, Administration Information :: D1, Administration Information :: B1))

Regards,

Jerry

Reply

Answer 13

Bagger50 Author

Level 1

0 points

Jan 23, 2013 12:08 PM in response to Jerrold Green1

HI Jerry,

I am getting this error message using this formula ?

not sure what I am missing here? Please help if you can, Also cell C2 I have a date 1-28 is there a way to make this progress with the following cells etc cells D2, E2, F2 etc. to automatically proceed after putting in frist date in cell C2? Thanks for all your help, B50

Reply

Answer 14

Bagger50 Author

Level 1

0 points

Jan 23, 2013 12:10 PM in response to Jerrold Green1

I do have a = in front of the ( IF ) in the formula that dose not show in picture, Thanks

Reply

Answer 15

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

Reply