Help with formulas

[robindspain]

Good afternoon guys.

I am looking for help with formulas for a time sheet.

I need to be able to convert time values from the xx:xx:xx (first column) format to decimal to use a multiply calculation for the cost.

Would like the decimal value for time in the first empty column.

I can then multiply the time by the cost.

Or in one formula do the conversion and multiplication

Many thanks for your replies

[#2 · Accepted solution]

@robindspain 

Assuming that you want to convert to decimal hours, multiply with 24.

So in a cell in row 2

=A2*24

and format the cell with the formula as General or as Number, or use

=A2*24*C2

and format the cell with the formula as Currency.

[#3]

Check this out. It converts hours and minutes to decimals and multiplied with the cost.

@robindspain