Time Sheet

[ebraun]

I am doing the payroll for the company i work and i would like to start using excel to figure out totel hours and totle pay but i dont know how to set a formula for over time, how do set the formula if the totel hours is 50 it should calculate 40 reg. hours and 10 over time

Thanks
Ebraun

 

[Pesky_Weasel]

ebraun,

I may be oversimplifying things here but the following may do what you require:

Assume A4 contains the total hours worked, B4 is regular hours, and C4 is overtime hours.

In B4: =IF(A4>40,40,A4)
In C4: =IF(A4>40,A4-40,0)

Regards
The Weasel

 

[wmuday]

I am not a power user on Excel but I was just experimenting with date and time calculations and decided just to go a little further and make a rudimentary payroll program.

The code would be too long to post on this message but I would be happy to send you the program as an email attachment.

If you wish, email me at wmuday@nwiis.com and I will send you the program.

 

[ebraun]

But i want to have only 1 coulmn for totel hours

a1 is time in
b1 is time out
c1 is totel hours
d1 is rate per hour
e1 is totel pay
now if c1 is more then 40 hours then in e1 it shold calculate the 40 reguler hours and 10 hours over time and it should give me the totel pay

Tahnks
Ebraun

 

[ebraun]

On 2002-11-03 11:33, ebraun wrote:
But i want to have only 1 coulmn for totel hours

a1 is time in
b1 is time out
c1 is totel hours
d1 is rate per hour
e1 is totel pay
now if c1 is more then 40 hours then in e1 it shold calculate the 40 reguler hours and 10 hours over time and it should give me the totel pay

Tahnks
Ebraun

 

[ebraun]

Please help

 

[VoG]

Where is the Overtime hourly rate?

Have you got the calculation of hours worked from time in/out figured?

 

[ebraun]

the over time rate is time and a half

 

[VoG]

The formula in E1 should be

=IF(C1<=40,C1*D1,40*D1+1.5*D1*(C1-40))

 

[phiber101]

I'm currently assigned as the equipment custodian in my workcenter and am trying to find out if I can get negative dates to appear in Excel. I have D4=Last inspection date, E4=Inspection date due, F4=Now(). trying to figure out how to set a command to have I4 as days overdue / days until next inspection?? can anyone help?