View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dean Dean is offline
external usenet poster
 
Posts: 93
Default convert [h]:mm:ss to real number that I can use as a multiplier

I am setting up a spread sheet to use as a time sheet for my son. I have use
used the time format in to cells. Next I used the [h]:mm:ss to calculate the
elapsed time.

Ok, that seemed to work just fine. Now I would like to multiply the
elasped time returned by a dollar value in another cell. It appears that the
value returned by the [h]:mm:ss operator does not return a real number that
can be used to multiply by.

I'm sure that there is some conversion that I just missing. I would like
to know how to fix this problem.

Dean