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

convert [h]:mm:ss to real number that I can use as a multiplier
 

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

convert [h]:mm:ss to real number that I can use as a multiplier
 

Hi Dean,

In Excel, time is stored as a fraction of a day. And a day is stored as 1.
So, to get a number of hours, multiply by 24. To get what you earn in
elapsed time, multiply the hourly rate by the number of hours.
Like: =Hourly_rate*Elapsed_hours*24


--
Kind regards,

Niek Otten
Microsoft 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

convert [h]:mm:ss to real number that I can use as a multiplier
 

What do you want to multiply by? Days? Hours? Minutes?

If it's days, use the time as is.
If it's hours, multiply the time by 24.
If it's minutes, multiply by 24*60

Regards,
Fred.

"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