HourMinuteSecond ( StartTime ; EndTime )
Adds the words 'hour, minute, second' to a calc time field.
Average rating: 4.4 (29 votes) Log in to vote
Miguel Angel Fernandez
HourMinuteSecond ( 12:00:00 ; 12:02:01 )
HourMinuteSecond ( 12:00:00 ; 14:00:00 )
2 minutes and 1 second.
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Very useful when you want to show the difference between two times. The calculation will show:
1 hour, two minutes and 1 second.
It will use plural or singular depending on the numbers.
Also available in Spanish.
Chris Coetzee, Cape Town
Feb 1, 2011
I am not that experienced in working with custom functions howver I have copied and pasted this funtion and created the Elapsed time function it seems without any problems.But it does nto work ! I am confused with the comment you make
"Adds the words 'hour, minute, second' to a calc time field."
What do you mean by this ?
So far I have a StartTime and EndTime field did the same in the Custom Function set up.
Miguel, León / Spain
Feb 22, 2016
I meant the function "says" n hours, n minutes and n seconds both singular and plural.
Douglas Alder, HomeBase Software
Sep 1, 2018
Mostly works. Problems arise if you enter an End Time that is before the Start Time.
For example: Start Time: 11 pm, End time: 1 am. Nothing is returned.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.