Help needed regarding calculating time

N

naga rajan

Hi,

Am having a set of numbers in A,B,C Columns.
Column A is for Distance
Column B is for speed
Column C is for Time

I have query value in D1.
If D1 is less than A1 it should calculate time on the following basis.
D1<A1 Then (D1-A1)/(B1*24)
If D1 is greater than A1 and less than A2 then it should be
C1+(d1-a2)/(b2*24) and so on.
If I drag the formula it is getting collapsed.
 

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

VBA Coding Help for Beginner 0
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Need help calculating probabilities 7
Conditional Time Calculation 10
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Calculating Project Time 1
Conditional Formatting and cloring cells and date calculations 1
I need to do a calculation based on the values in two cells 2

Top