I'm still learning (and I still have a long way to go) FM and I've search for several days on how to do a calculation on two fields from different records. I've imported a .csv file and have performed a find set on the records of interest. For example,
Location1 StartTime 8/1/2018 7:55:10am
Location1 EndTime 8/1/2018 8:05:23am
Location2 StartTime8/1/2018 7:45:01am
Location2 EndTime8/1/2018 8:10:18am
Location3 StartTime8/1/2018 7:30:45am
Location3 EndTime8/1/2018 8:01:10am
and so on.
What I'm trying to do is calculate the elapsed time between the StartTime and EndTime for the records for location1, location 2, location 3, and for approximately 110 more different locations for each weekday in the month. I've looked at the script functions, but haven't figured out the way to write the script. I've looked at maybe using another table occurrence to get the results I'm looking for and as before, I haven't learned enough to make it work. I'm using FM 17.
Is there anyone who would be willing to point me in the right direction?
Thank you in advance,