View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michaeljohnking
 
Posts: n/a
Default How can I calculate a value using time duration in mins & secs

The (A) cell containing the minutes and seconds is formatted as a "time"
cell. the other (B) cell is formatted as a "number" cell. When multiplying
(A) by (B) the result is not accurate.

"Bob Phillips" wrote:

=num_minutes*value_Per_minute

or am I not getting it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"michaeljohnking" wrote in
message ...
I want to calculate a value where one argument is minutes and seconds and

the
other is a value per minute.