Brian Dunning's FileMaker Custom Functions

TimeRange ( StartTime ; EndTime ; LimitHours )

Takes a start time and an end time and creates a text multikey field containing a list of all the times (minutes only, not seconds) in that range, inclusive.

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

Shaun Bicheno   Shaun Bicheno
Dale Technology
http://www.daletechnology.com

Share on Facebook Share on Twitter

  Sample input:
TimeRange ( 09:00 ; 09:06 ; 1 )
  Sample output:
09:00:00
09:01:00
09:02:00
09:03:00
09:04:00
09:05:00
09:06

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

Simply a modification of DateRange by Andrew Persons, Excelisys. I needed to use a TimeRange field for a surgery appointment solution with calendar interface and his was by far the most similar. Thought I'd submit it in case it saved someone some time.

Can be used relationally to give warning of overlapping appointments etc, without start or end times needing to match up.

Very handy for Diary / Calendar solutions.

Thanks to Andrew for DateRange!

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.