View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default Figuring cost based on hours

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?