try:

=Round(A1*86400*0.0166,2)

Format as number/currency

A1=Your time

"Dave Lee" wrote:

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