Hi,

Am Fri, 27 Apr 2018 11:40:46 -0700 (PDT) schrieb GARYWC:

Now, B16 contains 6.73 (Format Cells: Category: Number; Decimal Place = 2) (This is the distance (i.e., miles).

What formula will compute the miles-per-hour (MPH) of B16 / D16 ?

try:
=B16/((H16-F16)*24)


Regards
Claus B.
--
Windows10
Office 2016