Excel formatting

[Guest]

Hi,

I have an excel w/s which contains two columns - 'Duration' formatted as
hh:mm:ss and 'Cost' formatted as number x.xx. Is there an effective way to
establish a cost per minute?

Would appreciate assistance,

Don-

 

[Guest]

if A1 and A2 contain:
$20.34
1:34:23


then:

=A1/(A2*24*60)