Calculating total Overtime/Deficit Hours in and Adding.

[amanEngr]

I want to make an Attendance system in which i have to calculate the 'Overtime/Deficit Time' for each employee. I have done this successively. Now the problem is when i want to add the total overtime/Deficit time i got the value error in adding negative time(Deficit). Please help me how to[/CODE] do that.?? I will be thankfull

 

[kvsrinivasamurthy]

Format column G and M as number.
In G2
=24*(E2-F2)
In M2
=24*(K2-L2)
Time will be displayed in decimal value. It is easy for calculation.

 

[amanEngr]

I have solved the issue by using the 1904 date system. Thank You all