I am creating a Payroll System for my project as a senior student.

I already have the code for calculating the total hours worked and the corresponding

value for gross pay, net pay, deductions, etc.

My only problem is on how to calculate the total hours worked per day when the

user only inputs the In-and-Out time.

-> [8:00] - [12:00] / [1:00] - [5:00 ] - [Total Hours]

This is to remove the hassle of manually calculating for the total number of hours worked

by the employees.

 

I really need help on this one.

I hope somebody could help me.

I really want to learn.

Show the table structure of where time entries are stored and we'll come up with a sp or fn to calculate.

hi, im a 2nd year IT student,i got the same problem as yours,what i did is this:

[InAM] + [OutAM] = [TotalAM]

[InPM] + [OutPM] = [TotalPM]

[TotalAM] + [TotalPM] = [TotalHour]

i think i dont need to explain how to apply this logic in your program?

i managed to develope a payroll system with accurate DTR,All Deduction needed,etc.

My Family Company is now using it for payroll processing,and so far im not recieving any bad report regarding the system.

i cant post my entire system,but i can teach you some logic syntax.