Overtime

mtyrrell13

Board Regular
I am trying to calculate Overtime using one formula. Here is what I have so far

=SUM(C17*E17),SUM((E17/2) * (D17))

E17=Rate
C17=Regular Hours
D17=Overtime Hours

Can someone point out what I have wrong here

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

barry houdini

MrExcel MVP
mtyrrell13 said:
I am trying to calculate Overtime using one formula. Here is what I have so far

=SUM(C17*E17),SUM((E17/2) * (D17))

E17=Rate
C17=Regular Hours
D17=Overtime Hours

Can someone point out what I have wrong here

Assuming your hours are in time format, overtime pays half as much again as regular pay and rate is per hour

=(C17+D17*3/2)*24*E17

mtyrrell13

Board Regular
actualy no the time is in straight hours format 8 hrs straight time 4 hrs OT etc..

barry houdini

MrExcel MVP
mtyrrell13 said:
actualy no the time is in straight hours format 8 hrs straight time 4 hrs OT etc..

then you don't need to multiply by 24

=(C17+D17*3/2)*E17

Replies
3
Views
101
Replies
6
Views
244
Replies
2
Views
232
Replies
3
Views
89
Replies
6
Views
103

1,195,827
Messages
6,011,824
Members
441,648
Latest member
Bigjohnj

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.

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

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