Calculate wages based on boirs

[EBoudreau]

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.

 

[Michael M]

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]

Format cell I22 and I23 as custom...[h]:mm
which should return the correct hours

 

[EBoudreau]

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]

Glad it workd for you..