Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i need to get a total cost for time tracked. When I use a basic formula it
is incorrect, and I am not sure what I need to do. Ex: Hours worked: 208:30 Cost per hour is: $25 Total should be: $5,207.50 When I multiply I get $217.19!!!! I can't get the right answer. What sort of formula do I have to use? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
There must be some rounding errors going on. But you should be able to
multiply your answer by 24 and get the right figure. "Breezy77" wrote: i need to get a total cost for time tracked. When I use a basic formula it is incorrect, and I am not sure what I need to do. Ex: Hours worked: 208:30 Cost per hour is: $25 Total should be: $5,207.50 When I multiply I get $217.19!!!! I can't get the right answer. What sort of formula do I have to use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
figuring commissions based on gross sales | Excel Worksheet Functions | |||
Calculating cells cost hours | Excel Discussion (Misc queries) | |||
Figuring hours | Excel Worksheet Functions | |||
Figuring hours | Excel Worksheet Functions | |||
Figuring military time for total hours | Excel Worksheet Functions |