I want to calculate a value where one argument is minutes and seconds and the
other is a value per minute.

=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.

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.

Then =(A1*1440)*B1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"michaeljohnking" wrote in
message ...
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.