ETA ( StartTime ; Current ; OfTotal )

Gives the aproximate time a task will complete based on speed of each iteration

Average rating: 4.3 (25 votes) Log in to vote

Lee Dolereit
Sharp ABT
http://www.sofco.com.au

Sample input:

ETA ( GetAsTime("12:58 PM") ; 200 ;1000 )

Sample output:

16:05:45

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let(
	[
	ct = Get(CurrentTime);
	elapsed = Time(Hour(ct);Minute(ct);Seconds(ct)) - Time(Hour(starttime);Minute(starttime);Seconds(starttime));
	speed = elapsed / Current;
	remainrecords = Oftotal - current;
	remaintime = ct + GetAsTime(speed * remainrecords)
	];
GetAsTime(remaintime)
) // End Let

The ETA function will give you the estimated time a task will complete based on the time the task started, which iteration is currently being processed and the total number of iterations.
This can be useful for looping through large datasets during data processing, or can be used in conjunction with progress bars of any type.

Output is the estimated time of completion in HH:MM:SS.

To get the time remaining instead of the completion time, simply omit the 'ct +' from the 'remaintime' declaration.

Comments

		unix, Japan Feb 24, 2015
Could be simpler Let( [ ct = Get(CurrentTime); elapsed = ct - starttime ]; starttime + elapsed / Current * Oftotal ) // End Let and, may be better to return timestamp for midnight.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ETA ( StartTime ; Current ; OfTotal )

Comments

Support this website.

Support this website.