Hello I would like to ask how to calculate the arrival time.
For example:
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.
0
0
In cell C1
you place the formula:
=NOW()+((A2/B2)/24)
You must also format the cell as Time
(Format
>Number
>Time
)
In our formula we divide by 24
so as to convert the day duration to hours.
You could read more about NOW