View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrew Eagles Andrew Eagles is offline
external usenet poster
 
Posts: 3
Default Time * Rate = Amount Billed Formula?

I need to multiply the time recorded (in hours:minutes) by the charging rate
(in currency) to get the total amount billed as follows:

Time Billed Charge Out Rate Amount Billed

01:00 £285
02:30 £285

Please can someone tell me what formula to use, how to do this?

Thanks. Andy