hours multiplied by dollars

[John]

How can I set up a formula to multiple hours by a dollar amount?
I am creating a simple spreadsheet that will serve as my timecard.
Thank you,
John

 

[J.E. McGimpsey]

Times in XL are stored as fractional days, so to convert times to
hours, multiply by 24. Then you can multiply your hourly rate:

A1: 8:00 <== time as an Excel time
B1: 100 <== hourly rate
C1: =A1*24*B1 ==> $800.00 when formatted as currency

 

[John]

J.E., Paul,
Thank you both. I tried the formula that J.E. posted and it worked great.
Is there a way to have time dispayed as fractions or percentages of an hour?
Something like 6.5 hours (or 6 1/2 hours) as opposed to 6.30 hours (showing
the hour.minutes).
Thank you,
John

 

[J.E. McGimpsey]

Since XL times are stored as fractional days, just multiply by 24:

A1: 6:45
A2: =A1 *24 ===> 6.75

 

[Paul Simmons]

Hello John,

Try this, type the follwoing in the displayed cells:

A1 Day1
A2 Day2
A3 Day3
A4 Day4
A5 Day5

A7 Total Hours

A9 Pay Rate

A11 Total Amount

B1 8
B2 8
B3 8
B4 8
B5 8

B7 =SUM(B1:B5)

B9 8.75

B11 =B7*B9
Format cell B11 to display the number / currency format as you wish.

Hope this is what your after,
Pau

 

[John]

J.E. McGimpsey,
Thanks again, that worked.
John