ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to create new records of staff payroll (https://www.excelbanter.com/new-users-excel/209665-how-create-new-records-staff-payroll.html)

use the name

how to create new records of staff payroll
 
new staff payroll as at 31st jan 2008.
1.staff name
2.staff department
3.i.d
4.sex
5.transport,medical,housing,feeding allowance
you have to calculate no.5 through no.8 to get the total paid of each staff
are varies.
you have to subtract the salary of each staff from the gross paid to get the
net paid of each staff.

ShaneDevenshire

how to create new records of staff payroll
 
Hi,

This question is not clear, what exactly do you want? You could:

Take a copy of the old workbook and remove all the old data but keep all the
formulas, formatting and structure.

--
Thanks,
Shane Devenshire


"use the name" wrote:

new staff payroll as at 31st jan 2008.
1.staff name
2.staff department
3.i.d
4.sex
5.transport,medical,housing,feeding allowance
you have to calculate no.5 through no.8 to get the total paid of each staff
are varies.
you have to subtract the salary of each staff from the gross paid to get the
net paid of each staff.



All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com