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

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

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
 
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).
 
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
 
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.
 
Back
Top