View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Lee Dave Lee is offline
external usenet poster
 
Posts: 2
Default Need help with calculation - Duration or Time multiplied by cost

I am so rubbish with Excel but can normally muddle by but I am stuck with
this one.

I have a supplied spreadsheet that contain telephony information. The sheet
contains a duration column (no formatting, just general) that contains
figures like 00:00:44 and 00:15:48

I know that my per second billing is a value of 0.0166

Is there formula I can use to do duration * 0.0166 = cost ?

I hope this makes sense.. Thanks