Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using hours to multiply rate
hello community
can community guide me on this: Example that the difference of time is 10:00AM to 1:00PM = 3:00 hr I used the format [h]:mm to sum the total hours and I wanted to have the total hours multiply by say, $15.00 (which is the hourly rate) but my output result is 1.875 instead of $45.00 the working is (3:00 * 15) am I correct to use this formula ?? can community assist me on this ? thanks for the help :) -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using hours to multiply rate
Excel interprets 3:00 as 3/24 of a day; therefore you are multiplying
$15*(3/24). So, do 3:00*24*15 to cancel out the 24. Dave -- Brevity is the soul of wit. "tikchye_oldLearner57" wrote: hello community can community guide me on this: Example that the difference of time is 10:00AM to 1:00PM = 3:00 hr I used the format [h]:mm to sum the total hours and I wanted to have the total hours multiply by say, $15.00 (which is the hourly rate) but my output result is 1.875 instead of $45.00 the working is (3:00 * 15) am I correct to use this formula ?? can community assist me on this ? thanks for the help :) -- oldLearner57 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
using hours to multiply rate
thanks Dave F, very good explanation, much appreciated :)
-- oldLearner57 "Dave F" wrote: Excel interprets 3:00 as 3/24 of a day; therefore you are multiplying $15*(3/24). So, do 3:00*24*15 to cancel out the 24. Dave -- Brevity is the soul of wit. "tikchye_oldLearner57" wrote: hello community can community guide me on this: Example that the difference of time is 10:00AM to 1:00PM = 3:00 hr I used the format [h]:mm to sum the total hours and I wanted to have the total hours multiply by say, $15.00 (which is the hourly rate) but my output result is 1.875 instead of $45.00 the working is (3:00 * 15) am I correct to use this formula ?? can community assist me on this ? thanks for the help :) -- oldLearner57 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Adding Time | Excel Discussion (Misc queries) | |||
how can I multiply number of hours and minutes by hourly rate? | Excel Worksheet Functions | |||
Rate Calculation | Excel Discussion (Misc queries) | |||
How do i multiply an hourly rate by hours in Excel? | Excel Discussion (Misc queries) | |||
How do I multiply rate per hour by hours worked. | Excel Worksheet Functions |