Figure out Vacation hours into $ amount

[rx7andrea18]

I been trying to find a formula to convert Vacation hours into $ amount so 42.1 hours = to $ how much... can someone help me out because i think my work is trying to screw me over

Capture.PNG

[rx7andrea18]

could anyone help me?

[AliGW]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been a few hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[rx7andrea18]

totally understood i should have read the rules of the forum. point noted and it won't happen again.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[rx7andrea18]

hopefully this works

[JeteMc]

As far as I can tell from Book1.xlsx the formula to get the vacation earned in $ amount would be: =C39*H15
If that isn't correct then it might be helpful to know if the formula in cell C39 is correct.
To me it looks as if the formula is the sum the salary and bonus amounts multiplied by the percentage and then divided by the hourly salary amount.
If that isn't what it is supposed to represent then please provide us with that information.
Let us know if you have any questions.