Time Sheet

ebraun

Board Regular
Joined
Sep 1, 2002
Messages
141
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
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Pesky_Weasel

Board Regular
Joined
Sep 28, 2002
Messages
99
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

New Member
Joined
Nov 1, 2002
Messages
10
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

Board Regular
Joined
Sep 1, 2002
Messages
141
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

Board Regular
Joined
Sep 1, 2002
Messages
141

ADVERTISEMENT

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
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650

ADVERTISEMENT

Where is the Overtime hourly rate?

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

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
The formula in E1 should be

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

phiber101

New Member
Joined
Nov 2, 2002
Messages
2
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?
 

Forum statistics

Threads
1,144,059
Messages
5,722,272
Members
422,419
Latest member
Havok390

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top