Sep 19 2019 02:50 PM - edited Sep 19 2019 02:52 PM
Sep 19 2019 03:08 PM
As a comment, that's not exactly the Excel question. If you have a logic how the result shall be calculated, expressed in words or with on-paper formulas, this community help translate it into Excel formulas.
However, perhaps someone knows the answer.
Sep 20 2019 01:14 AM
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)