# Calculate wages based on boirs

#### EBoudreau

##### Board Regular
Title of my thread got messed up on me. Supposed to ready “Calculate Wages based on time but format messing up calculations.

I seem to be missing something here, and all I have is a screenshot of my spread sheet for reference because I’m working off my phone for right now....

But basically here is what I’m trying to figure out:

In cell I22, I want to reference cell I20 and calculate: IF I20 is > 40, then just input 40 hours. If not then return the value that is in I20.
Then in J22, I want to multiply I22 with F22 to calculate the amount of Regular time pay an employee has received. I think formatting is messing me up on that one.

Then in I23, I want to take I20 and subtract I22.
Then in J23 I want to multiply I23 with F23 to calculate the amount of Overtime an employee has received.

The formatting of I22 and I23 I think are throwing off the calculations of the \$ totals because I am not getting the correct results.

Any ideas or guidance would be greatly appreciated.

#### Attachments

• CD2E5CF0-8072-4DCB-BBBA-771AECB729A8.jpeg
188.8 KB · Views: 6

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### Michael M

##### Well-known Member
How are the time cells formatted ?
It looks like thery are in time format ?
Why not simply use normal numbers with 15 min increments, ie, 10.25, 10.5 etc !

#### Michael M

##### Well-known Member
Format cell I22 and I23 as custom...[h]:mm
which should return the correct hours

#### EBoudreau

##### Board Regular
How are the time cells formatted ?
It looks like thery are in time format ?
Why not simply use normal numbers with 15 min increments, ie, 10.25, 10.5 etc !
I went ahead and did that. Just makes more sense cause we usually round up the nearest 1/4 hour so that’s just easier.
The other way with the special formatting did work as well. But we’re not tracking down to the minute.
Thanks for the assistance.

#### Michael M

##### Well-known Member
Glad it workd for you..

Replies
1
Views
107
Replies
172
Views
2K
Replies
0
Views
191
Replies
18
Views
2K
Replies
1
Views
265

1,147,744
Messages
5,742,948
Members
423,766
Latest member
dafydd_jwc

### 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?

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