Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Steve
Excel stores times a fractions of a day, so multiply your result by 24. with time in A1, rate in B1 =A1*B1*24 -- Regards Roger Govier "Steve Tupper" <Steve wrote in message ... I want to get XL to give me the result of the following type of calculations: 41hr 55mins (entered into a cell as 41:55:00 ?) multiplied by the rate per hr entered in another cell as a monetary amount of say 563.50 to give the resultant cost in a 3rd cell. I want to be able to enter time as hrs & minutes NOT as hrs and a decimal of an hr. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with calculation - Duration or Time multiplied by cost | Excel Worksheet Functions | |||
need to calculate time multiplied | Excel Worksheet Functions | |||
Figure time multiplied by currency | Excel Worksheet Functions | |||
Time by cost | Excel Discussion (Misc queries) | |||
time format multiplied by hours worked ? | Excel Worksheet Functions |