Hourly based wages

In my factory i need to calculate wages on hourly attendance, total number of hours is being calculated in auto attendance but i find no way to use inside calculation of salary,

Note i can’t create timesheet because it’s difficult to maintain 250 workers timesheet manually

Anyone can help how i can use the working hours calculate in attendance and use it solely for salary

My salary calc. formula is (wage/8) * hours worked

@NCP Help kari dyo bhai

Update i have created new custom app which will run together with auto attendance marking, now problem is i have timesheet for each day seperately for each worker.

Working out how i can merge these timesheet into one for that perticular month

You Can update the data in excel sheet and import the data using Data Import tool to timesheet doctype.

Instead the timesheets are generated via attendance through the script that I made