TimeRounder ( theTime ; toTheNearest )

Rounds the time to the nearest amount

Be the first to rate this function Log in to vote

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

TimeRounder ( 1:08 PM; 5 )
TimeRounder ( 1:08 PM; 15 )

Sample output:

1:10 PM
1:15 PM

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

/*
 *  CUSTOM FUNCTION
 *    TimeRounder ( theTime; toTheNearest )
 *
 *  DESCRIPTION
 *    Rounds the time to the nearest passed value
 *
 *  PARAMS
 *    theTime: the time to round
 *    toTheNearest: the nearest value to round to
 *
 *  RETURNS
 *    Time
 *
 *  DEPENDENCIES
 *    --NONE--
 *
 *  CHANGELOG
 *    2022-02-25: Paul McCudden (paul@peak14.solutions): Created
 *
*/

Let (
  [
    ~time = GetAsNumber ( GetAsTime ( theTime ) );
    ~nearest = GetAsNumber ( toTheNearest );
    ~min = Mod ( GetAsTime ( theTime ); 3600 )
  ];

  GetAsTime ( Case (
    ~time = "?"; "0";
    ~nearest = 0; "0";
    theTime - ~min + Round ( ~min / 60 / toTheNearest; 0 ) * 60 * toTheNearest
  ) )
  
)

Takes an input time and rounds it to the nearest value. If an error happens, it will return "0" as time.

Comments

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

TimeRounder ( theTime ; toTheNearest )

Comments

Support this website.

Support this website.