Formula Help

J

JDT

Sorry if this was repeated. Having ISP problems.

Formula Question

Example:

Name Result $ Hours/Minutes

Jane +100 1:00
Bob -50 2:50
Bob +125 3:12
Ed +325 7:45
Jane +50 :55
Ed -150 1:37
Jane -25 2:50

Jane earned $125 in 4 hours and 45 minutes. How do I write a formula
in a single cell to determine Jane's hourly rate that will
automatically update as more data is added?

Thanks.
 

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

Formula Question 2
How to set up a formula that it adds value on a certain date 5
Pivot Table Filter Formula 1
adding hours and minutes 7
simple formula I'm sure using offset? or index? 2
formula to display cell address 2
work out how many trucks came in between the hours of 9am and 3pm 1
need help finding most common number and so on 2

Top