Thread: Formula Help
View Single Post
  #1   Report Post  
JDT
 
Posts: n/a
Default Formula Help

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.