How can I calculate a value using time duration in mins & secs

M

michaeljohnking

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

Bob Phillips

=num_minutes*value_Per_minute

or am I not getting it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
M

michaeljohnking

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

Bob Phillips

Then =(A1*1440)*B1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative time calculation in Excel 2003 3
Calculate the median value before a specified list 0
MS Project. Real progress of the project, % complete 1
how can i convert a value quoted in hrs,mins,secs to just mins 1
Formatting question: how to format duration (time spent)? 0
Calculating a Target time from an Actual Time... 2
Time Sum in Excel 1
Calculating Phone Bills Help Please 4

Top