Hello I would like to ask how to calculate the arrival time.
I have 1 cell where I put km which are left for 1 truck.
I want to calculate the current time + the cell where I write the km left and to calculate on another cell the arrival time with speed 80km/h.
C1 you place the formula:
You must also format the cell as
In our formula we divide by
24 so as to convert the day duration to hours.
You could read more about