Converting time

[Liz]

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.

 

[Dave R.]

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.

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.

 

[Dave R.]

also there is HOUR which will give you the 0 part, or 1 from 1:14 for
example.

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.

 

[Eric]

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