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 - Show more from this author
Dale Technology
http://www.daletechnology.com

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)

Case( 

IsEmpty ( StartTime ) or IsEmpty ( EndTime ) ; "Please fill in both fields." ;

StartTime > EndTime ; "Start time must be earlier than end time." ; 

( EndTime - StartTime ) > ( LimitHours * 3600 ) ; "Time range has exceeded the limit of " & LimitHours & " Hours." ;

Case ( EndTime > StartTime ; 

TimeRange ( StartTime; EndTime - 60 ; LimitHours) & "¶" & EndTime ; EndTime

))

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

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

TimeRange ( StartTime ; EndTime ; LimitHours )

Comments

Support this website.

Support this website.