What does it return. My guess is it returns something formatted with
[h]:mm:ss. If so, that **is** a real number (date values are integers and
time values are decimals)... just format the cell as General and it should
give you the correct multiplication (actually, if you are multiplying by a
currency value, you might want to format the cell as Currency).

--
Rick (MVP - Excel)


"Dean" wrote in message
...
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