If A1 contains distance and B1 contains speed in mi/hr, then =A1/B1/24 is the time (in days). Format as [h]:mm to see 2:30.
If A1 contains distance and B1 contains speed in mi/hr, then =A1/B1/24 is the time (in days). Format as [h]:mm to see 2:30.
Entia non sunt multiplicanda sine necessitate
Brilliant, Thanks and the answer was so simple.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks