Current Time =

Distance To Go =

Average Speed =

Est Time Of Arrival =

This template will return an ETA given current time, remaining miles (or kilometers) to drive and average MPH/KPH. Current time is entered in military format (HH.MMSS). The program first converts all time values to fractions with the HRS function. Once the calculations are complete, it then converts the fractional time values back to (HH.MMSS) with the HMS function.

If an ETA greater than 24.0000 but less than or equal to 48.0000 is returned, then you are into the 2nd day. In this case, subtract 24.0000 from the result. If an ETA greater than 48.0000 but less than or equal to 72.0000, is returned, then you are in the 3rd day. In this case, subtract 48.0000 from the result.

In a great majority of the cases, the returned ETA will be in the 1st day.

NOTE: Distance to Drive and Average Speed must reference the same unit. If Distance to Drive is in Miles then Average Speed should be in Miles per Hour. If Distance to Drive is in Kilometres then Average Speed should be in Kilometres per Hour.

(Please refer to the examples).

Contributed by Clarke Blackman; updated by Infinity Softworks

1) Enter Current Time - 10.2500 (10:25 AM)

Enter Distance To Drive - 500

Enter Average Speed - 70

Solve for ETA = 17.3334 (5:3334 P.M. - 1st Day)

2) Enter Current Time - 14.3000 (2:30 PM)

Enter Distance To Drive - 800

Enter Average Speed - 70

Solve For ETA = 25.5543 (25.5543 - 24.0000) = 01.5543 (1:5543 AM - 2nd Day)

3) Enter Current Time - 23.3000 (11:30 PM)

Enter Distance To Drive - 1,800

Enter Average Speed - 70

Solve For ETA = 49.1251 (49.1251 - 48.0000) = 01.1251 (1:1251 AM - 3rd Day)

Current Time

Distance To Go

Average Speed

Est Time Of Arrival

-------------