Forum Discussion
Formula
Can I create a formula to output a time based on a start time of 0800 and distance travelled at a certain speed? Eg start travelling at 0800 at 19.3121km/ph the first junction is at 0.4km. I want a f...
Given the Speed (kph), Junction, and Distance in Columns A:C, the formula in D2 of the attached file is:
=SUM(IF(ISNUMBER(D1),D1,
F$2),
C2/A2/24)