Creating employee attendance

[hidetoshi76]

Hi there,

Good day all.

i'm creating employee attendance sheet and link it to salary payroll for the month of October.

I just want it to be realistic .If the staff is sick/vacation/no show . How i adjust it and the employee time sheet will make adjustment and notified that the staff if absent and auto deduction the salary.

i'm attaching what i have done.

Appreciating if anyone can help... as i need to get it done before end of mth..~

Thanks..

[AliGW]

Where is the sickness/vacation/no show data stored?

[hidetoshi76]

Actually i haven't input it yet..

plan to put it inside one of the staff eg Gordon ramsey sheet.. beside the OT can add in the cell name Sick/Vacation..

Thanks.~

[BadlySpelledBuoy]

I think it would be helpful if you could add some sick/vacation/no show data and repost your attachment. It will make it much easier to help you if we can see how you plan on recording it.

BSB

[AliGW]

OK - so please could you provide a sample workbook with some dummy sickness/vacation/no show data added?

[Beamernsw]

I've made a heap of small changes here just as some suggestions.
It obviously doesn't allow for any leave loading in the pays, and as I said in my notes, I assume that the 1.5 for OT means 1.5x payrate, not $1.50 /hour.
Anyway, here's some ideas to get you a bit further hopefully.

Edit: Oh... only changes I made were in "Adrianne Curry" and "Payroll".

Edit2: Oops, formula in Adrianne Curry!B6 should be =A10

[hidetoshi76]

Hi there...im adding a dummy excel for your references..

Hope this can help~~

Thanks

[AliGW]

This is a completely different set of data with different people. Please provide the data requested as part of the original workbook.

[hidetoshi76]

Hi there...

here is the original data .

Tq..~

[hidetoshi76]

Hi there,

This is the excel with the cell with sick/vacation/no show...


Thanks.~

[AliGW]

But you have not included any dummy data in the new column! How is it going to be filled in? And how and where do you want it summarising on the summary sheet? You aren't making this easy!

[Beamernsw]

Did you find any of the suggestions in my file to be of any use?
Or maybe I misunderstood the question?
Quite tired so....very possible

[hidetoshi76]

Hi there,

I did check the changes u made today. seem like is like what i want it to be.
Anyway when i open the excel that u send it said something of error data. what microsoft excel did you use to make changes.?

Thanks~

[Beamernsw]

Excel 2010, and I have the same error showing now. But all the data seems to be there...no idea

Although I just noticed a mistake in Cell N10 of Payroll.

It should be =J10*$L$10*K10

[hidetoshi76]

Hi there,

Seriously by far your the best solution...although some i not really sure about it ...as i'm a excel geek....
anyway just want to ask . on the excel you did stated 'insert column with drop down to choose sick/no show/holidays/etc ...did u insert it or just a suggestion to add it in by me..~

[Beamernsw]

I did add it in column C. Apparently that is the data that was lost
It won't keep it when I save as xls 2003, hopefully you can open this one.

[hidetoshi76]

Hi there,

Actually after that i can see it ...but tis one u send in didnt show any more error on the data...

Anyway...u solved my issue... i guess i cant use this excel for the time being...

Thanks alot again!! for the help! u saves the day..!