Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |