how to calculate an rate per minute

  • Thread starter Thread starter n1kk1
  • Start date Start date
N

n1kk1

Hi, im having an absolute nightmare with this so any feedback would b
fantastic

I need to enter a formula to calculate a column with hh:mm:s
(formatted for TIME) against a minute rate. So 00:00:30 at 20p a minut
would be 10p - help!

thn
 
try this
where A1 = 20
20 equalling your 20p dont put p or formula wont work
then you can change it also so if it become 30p that will change th
outcome
and
A2 = time

A1/60 divids into seonds
* A2 seond multiplied by the time
= your answer


=(A1/60)*A
 

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

how to calculate an rate per minute 1
calculateing 1
calculate a rate per minute 3
Excel Excel calculate pay based on rate per minute 7
how do I convert pace per mile to total time in minutes in excel? 2
minutes calculation formula 3
Calculating Times for Pay Rates 4
Calculate parts per hour on rotating line 6

Back
Top