Call cost per minute problem

[SRL]

Morning all

I'm sure there's a simple answer to this but I haven't found it yet.
I have a column (A) of "Total minutes" in time format "hh:mm:ss" and
"cost per minute" column (C) in currency format e.g. €0.30. All I wan
to do is multiply the two to arrive at the total cost for the total tim
(column B)

Where A2 = "02:03:04" and C2 = "€0.10", I tried A2*60*C2, which wa
something I saw on another thread, and got €0.51 in B2 which clearl
isn't correct (if only it were...!). No doubt I'm missing somethin
fundamental so if anyone has a solution, I'd be eternally grateful :


Thanks heaps
SR

 

[Bob Phillips]

24*60 minutes in a day, not just 60

=A2*24*60*C2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[SRL]

Hurrah! I knew it would be something basic but beyond my capabilitie
at this hour

Thanks, Bob and have a sunny day