Convert time hh:mm to a decimal.

I am importing a time report from Quickbooks to Excel. The time format comes in hh:mm.  I want to multiply that time by an hourly rate.

I am using MS Office 2003.  I have tried the suggestions in MS help such as CONVERT, INT. I have pasted my spreadsheet details below.

I figured it out. 

For completeness and to close the thread, I suspect the OP had noticed that a time in excel is a decimal of a day (a day being 1), so 12 noon is .5 and so on.

So to multiply times by hourly rate for example, you have to multiply the hours by 24 to get days, so, if you have a time of 8 hours at £20 per hour then the formula would be With time in A1 and rate in B1

=(A1*24)*B1

Should give you 160

You can do no better than check out here www.cpearson.com/excel/datetime.htm