FormatTimeHHMM12 ( theTime )

Format time in HH:MM 12 hour format

Be the first to rate this function Log in to vote

Robert D Trammel - Show more from this author
https://www.linkedin.com/in/robertdtrammel/

Sample input:

FormatTimeHHMM12( Get( CurrentTimestamp ) )
FormatTimeHHMM12( Time( 17; 30; 0 ) )
FormatTimeHHMM12( "12:30:00" )
FormatTimeHHMM12( "0:15:00" )

Sample output:

4:01 PM
5:30 PM
12:30 PM
12:15 AM

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

Let([
   t = GetAsTime( theTime );
   hr = Case( 
      Hour( t ) > 12; Hour( t ) - 12; 
      Hour( t ) = 0; 12;
      Hour( t ) 
   );
   mn = Right( "00" & Minute( t ); 2 );
   ampm = If( Hour( t ) > 11; "PM"; "AM" )
];
   If( t  ≠ "?"; hr & ":" & mn & " " & ampm )
)

There are probably a dozen and a half ways to do this, but I found that this was a really nice simple function that will format something specifically as hh:mm am/pm.

Comments

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

FormatTimeHHMM12 ( theTime )

Comments

Support this website.

Support this website.