I need some help writing a new formula for a project I am working on.
The current formula is based on amounts listed in cell c20 to come up with a total value of hours and minutes based on the number in C20. Cell e20 contains hours and f20 contains minutes.
The sum of these values works great and it totaled up in cell g20.
The current equation is written as =+(C20*E20)+((C20/60)*F20). This shows the result in G20 As I said this works great.
Using this current equation gives me (1320*6)+((1320/60)*5)=8,030 for my current grand total.
There is a new part I need to factor into this equation for bonuses. It is based on a percentage of c20 to be added to c20 to be used in the above equation. Here is an example:
(C20*$b$4)+c20=new total
(New total*e20)+((new total/60)*f20) = new grand total needed in cell g20
So (1320*19%)+1320=1570.80 (1570.80*6)+((1570.80/60)*5)=9,555.70
I know I can do this by creating another column doing the first equation, then referencing the current equation off the new column. I would rather not do that. I figure there must be a way to modify my current G20 equation. I'm not very good with complex equations.
Thank you.
