Calculate hours & wages?

Hi everyone,

I'm using Excel to keep track of my hours at work, which is great. What I'd love to do is have the total hours multiplied by my hourly wage in another column, so I can know what to expect on my paycheck. I thought it was as simple as clicking another cell and choosing the Total Hours cell and multiplying it by the hourly wage but that doesn't seem to work.

My Total Hours cell (E4) is formatted using [h]:mm:ss. If I try and simply multiply, like =E4*wage, I get an odd number, that I think is formatted as time. If I try to change it to currency, I get a really small number like $10.78, and it's the same result if I switch the formatting to General or just Number.

What am I doing wrong? What formula am I supposed to use, or am I using the wrong formatting?

Any help or insight would be appreciated. Thanks everyone!
- K

Hi and welcome to the forum
Could you post a sample of your data so that we can see where it went wrong?
Thx

You need to understand the way excel treats time. One day = 1 in excel so 8 hours, for instance, is 1/3. You need to convert the time value e.g. 8:00 to a decimal value 8 which you can do by multiplying by 24, so you can calculate your wages with

=E4*24*wage

Thanks everyone, multiplying by 24 worked!

- K

Great! 24 worked for me as I was facing exactly same issue as mentioned in original question! Simplest and easiest! Thank you, daddylonglegs!