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.
Add a comment
|
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
answered Nov 22 '19 at 8:22
