0

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

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.

enter image description here

You could read more about NOW

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.