We need to insert the below formula in cell B4. Using simple mathematics, we can calculate the missing values in the above example. So how much time will it take to reach a destination if we drive at 30 Km/hour?

Excel functions, formula, charts, formatting creating excel dashboard & othersįor Example – If we drive a bike at 60 Km/hour and reached a particular destination in 1 hour, and if we drive at 45 Km/hour and reached a particular destination in 45 minutes.