Thanks Harlan,

this is what I figured out, I took the 20:30 times 24 then times the hourly
rate and that made it come out correctly.

Thanks for the help.

Jeff

"Harlan Grove" wrote in message
oups.com...
"Jeff" wrote...
...
I have the end of week total and that cell is formatted as suggested below
[h]:mm, the new problem I am having is that I have a cell for hourly rate
but when I multiply Total Hours Worked by Hourly Rate I am getting a wrong
amount. Example:

Total Hrs 20:30 x $10 Hourly Rate is giving me $8.54

How can I now get the Hourly rate to recognize Total Hours as a number?
...

You need a tutorial on how times (and dates) work in Excel.

Times are fractions of days, so 1:30 AM equals 1/24 + 1/48 = 3/48 =
1/16 = 0.0625.

Also, number formatting has NO EFFECT WHATSOEVER on values. A time
value formatted to appear as time, [h]:mm, of 20:30 is EXACTLY THE
SAME as the number 41/48 = 0.854166667. It's NOT equal the number
20.5.

Convert times (fractions of days) to equivalent number of hours by
multiplying them by 24. The formula

="20:30"*24*10

returns 205.