hours multiplied by dollars

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
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
 
Since XL times are stored as fractional days, just multiply by 24:

A1: 6:45
A2: =A1 *24 ===> 6.75
 
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
 
Back
Top