1 of 1 people found this helpful
Date, Time and Timestamp fields are essentially number fields that count out intervals of time from an arbitrary zero or starting point. A time field stores the number of seconds from midnight to the time displayed as hours, minutes etc. in the field. So if you add a number to a time field, you add that many seconds to the time shown.
YourTimeField + 1800
adds 30 minutes (in seconds) to the time in YourTimeField.
Here is a file and attached screen shot of the script. Keep in mind that you will need to address the amount of students and what the maximum time slot (last appointment) should be. This script works on the “Found Set”. Time calculations can be difficult to understand.
In the attached file, I set the Starting time in the Global field to be 30 minutes less than actual starting time. The script adds 30 minutes (1800 seconds) to set the student appointment time.
60 Seconds = 1 Minute
3600 Seconds = I Hour
86,400 Seconds = 24 Hours.
Time is calculated from Midnight to Midnight
It would be a good suggestion to review the Time fields documentation available in Filemaker . Time calculations can be difficult to understand.
Did you ever get this to work as desired?