Calculate wages based on boirs

EBoudreau

Board Regular
Joined
Aug 21, 2015
Messages
143
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
    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
Joined
Oct 27, 2005
Messages
21,104
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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 !
 
Solution

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
21,104
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Format cell I22 and I23 as custom...[h]:mm
which should return the correct hours
 

EBoudreau

Board Regular
Joined
Aug 21, 2015
Messages
143
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
Joined
Oct 27, 2005
Messages
21,104
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Glad it workd for you.. (y) :cool:
 

Forum statistics

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

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