HRS to whole number

[proctk]

Hi

I have a number in a cell that is formated as 37:30, I want to be able to multiple this number by a value in another cell (Units per hour)

So the formula would look like 37:30 * Units.

The problem is I need to keep the hours value in time format. I need to convert it to a number some how to use in the formula... so 37:30 should = 37.5.

Thank you

 

[Andrew Poulsom]

To convert a serial time to decimal hours multiply by 24.

 

[mfexcel]

Do you need TIME? | wmfexcel

Hi

I have a number in a cell that is formated as 37:30, I want to be able to multiple this number by a value in another cell (Units per hour)

So the formula would look like 37:30 * Units.

The problem is I need to keep the hours value in time format. I need to convert it to a number some how to use in the formula... so 37:30 should = 37.5.

Thank you