### Title

Time Schedule Calculation

### Post

I am building a database of timepoints for bus routes. I want to put in the starting time in the first field, and have the remaining fields filled in automaticaaly based on adding minutes.

Eample time points:

- Lorene & 7th - Enter time manually (6:00 AM)
- Dante & Venus - 15 minutes after previous (Lorene & 7th) (6:15 AM)
- Transit Center - 15 minutes after previous (Dante & Venus) (6:30 AM)
- Oro Grande - 25 minutes after Transit Center (6:55 AM)
- Depart - 5 minutes after Oro Grande (7:00 AM - this would also become the next Lorene & 7th time))

Then have the next Lorene & 7th time equal the previous Depart time.

Want to start this at 6:00 AM and have one every hour until 8:00 PM. Or repeat until a certain hour or number of times.

Thanks in advance,

Craig

Yes, as written, you'd need to limit your found set to just one bus schedule at a time.

This expression should work for multiple schedules in one found set (but be careful how you sort these records...)

If ( StartTime ; StartTime ; If ( Get (RecordNumber) > 1 ; GetNthRecord ( cArrivalTime ; Get (RecordNumber ) - 1 ) + ElapsedTime * 60 ) )