View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Multiplying time values and numbers

In arriving at the figure you think it should be, you have taken 10x40
+ 15*15.45, whereas you should have taken 10x40 + 15x15.75, as 45
minutes is .75 hours. The formula works fine and gives the correct
answer (checked on a calculator).

Hope this helps.

Pete