Payroll In Excel - How to establish a payroll system - formula required

Hi Friends,
Let me introduce my self. My name is Asrar and I am working as an HR-Executive in Synfosys. I have 3 years of experience in HR. For the past 4 months I have been trying to make payroll in excel sheet but i am stuck. I don't know what to do. I am planing to make attendance of full month and daily time in and time out with number of breaks. Can any one let me know how to write some formulas. You can also mail me at [Login to view] or [Login to view]

Hi ..
Check thiese attachments.
Whether they are useful or not.

can any one tell me the hr general administration packages for 1to 2 yrs of experience in chennai SME level IT company