Calculations

[Guest]

I am not to good with Excel.

I have to make up a time sheet. Right now my "total weekly hours" box has a
time format of 'h:mm'. I need to calculate that by and hourly rate and then
into the dollar figure. Everytime I trie I get a very small fraction of the
actual dollar amount. Can someone help me?

an example: I worked 11:30 (11 and a 1/2 hours) at $15.00/hr. That should
equal $172.50 but Excel says it equals $7.19. I know I need to probably
convert the 11:30 to 11.5hrs but how?

Thanks in advance for the help

 

[Guest]

The time is a fraction of a 24 hour day. It is really thinking that your
11:30 is 11:30 in the morning as opposed to 11 and 1/2 hours.

Multiply the result by 24. 7.19*24 = 172.50

 

[Guest]

Thanks. It worked and I am less frustrated than I was a while ago.

I am so useless with formulas in Excel. Give me a pen and paper and I'll
have no problems, but everbody wants things done on computers anymore.