how to compute attendance time sheet

[gerard_gonzales33]

Hi Everyone!

I have created a employee time sheet (individual attendance report), some of the formulas were came from this forum. Thank you very much!. And as time passed by as I use it, some things I realized that this file can do more and make my task faster and easier. My queries are as follows:

1. How can I make a summary report of multiple sheets (data). Making multiple sheets into one summary file (merging).

2. Can the merging of sheets be in alphabetically order? (auto sort- ascending order)

3. I have an existing formula on column K and L, how can I include in the formula for computation under the column G;H; or I ( filed leave its either 4.00 (for half day) or 8.00 (for whole day)). And is it possible the sum or the total of column G;H; or I be converted into days?

[ncmay]

See if the attached Attendance workbook will be helpful.
It will work with up to 50 employees, just make copies of the employee sheets.

[nathaliecruz]

Hi,

We have been using cloud-based employee time card software from Replicon. When this software was introduced, it didn’t have a great welcome at our office as it altered many of the methods we’ve been following for years. However, we found that we’ve got the best software that made our work easier.

Try out some hassle free application!

[nikakims]

This is an amazing excel sheet! My question is, could this excel sheet be modified to be used for a point system based attendance? All employees start with 8 points at the beginning of the year. Tardy < 4 hours = .5 points, >4 hours 1 point. NC/NS 3.5 points, etc? Thank you