Converting time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to format time as a general number, so that I can use it in an equation.
I currently have 14 minutes as 0:14. I want to be able to multiply 14 minutes by a factor that is dependent upon time for example $14/ min.
 
If you've entered 14 minutes as 0:14 (a number) in A1, simply use MINUTE(A1)
and you will get 14, then mutiply that by whatever.


Liz said:
Does anyone know how to format time as a general number, so that I can use it in an equation.
I currently have 14 minutes as 0:14. I want to be able to multiply 14
Click to expand...
minutes by a factor that is dependent upon time for example $14/ min.
 
also there is HOUR which will give you the 0 part, or 1 from 1:14 for
example.


Liz said:
Does anyone know how to format time as a general number, so that I can use it in an equation.
I currently have 14 minutes as 0:14. I want to be able to multiply 14
Click to expand...
minutes by a factor that is dependent upon time for example $14/ min.
 
Liz,

Excel stores that 0:14 as a fraction of 24 hours. So, if
you multiply that by 24, you will get 0.2333 or 23.3
hundredths of one hour. If you multiply that by an hourly
rate, you should get the right answer.


Eric
 
Back
Top