TimeCorrect ( TimeEntry )

Enter time in a time field with or without colons (:) and convert to valid time

Average rating: 4.4 (7 votes) Log in to vote

Menno van Beek - Show more from this author
Van Beek Zakelijke Software
https://www.vbzs.nl

Sample input:

TimeCorrect ( 023 )
TimeCorrect ( 15 )
TimeCorrect ( 537 )
TimeCorrect ( 11:15:30 )
TimeCorrect ( 1630 )
TimeCorrect ( 8 )
TimeCorrect ( 34:30 )

Sample output:

0:23:00
15:00:00
5:37:00
11:15:30
16:30:00
8:00:00
10:30:00

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

/*
###################
#  
#  TimeCorrect function 
#  
#  Format:
#  TimeCorrect ( TimeEntry )
#  
#  Parameters:
#  TimeEntry - Enter a short version of time 023 or 1 or 15 or 1:23
# 
#  Data type returned:
#  Time	- imput is converted into a valid time. Time entered > 24h like  
#  25:00 will be modulated into 1:00:00
#    
#  Description:      
#  Cuts of the last 2 digits and the 2nd colon of any timestring found in a 
#  text, no rounding is applied.
# 
#  20220210 Replaced function that initialy was published in 2018
#  
#  ©2021 - Menno van Beek - Van Beek Zakelijke Software - the Netherlands
# 
###################
*/

Let ( [ 

	value = Substitute ( GetAsText ( input ) ; [ ":" ; "" ] ) ; 
	l = Length ( value ) ; 
	t = GetAsTime ( 
		Replace ( 
			Replace ( 
				If ( Mod ( l ; 2 ) ≠ 0 ; "0" ) & 
				value & 
				Case ( l ≤ 2 ; "0000" ; l ≤ 4 ; "00" ) ; 
			5 ; 0 ; ":" ) ; 
		3 ; 0 ; ":" ) ) ; 
	e = Mod ( GetAsNumber ( t ) ; 86400 ) ; 
	h = Hour ( GetAsTime ( e ) ) ; 
	j = If ( t > 0 and e = 0 ; 24 ; 0 )

] ; 

	Time ( 
		If ( j ; j ; h ) ; 
		Minute ( t ) ; 
		Seconds ( t ) )

)

Very simple function to give users the ability to enter times like 925 instead of 9:25. This can be used in script or as auto-entry option in a time field or in calculations and scripts.

EDIT: Feb 10, 2022 Replaced function for a more robust version.

Comments

		jmmiro, Aprodisca Sep 28, 2018
molt Ãºtil, grÃ cies

		jmmiro, Aprodisca Oct 9, 2018
Solo funciona si el campo es de texto, si el campo es de hora, los calculos son incorrectos

		Menno van Beek, Van Beek Zakelijke Software Oct 9, 2018
@jmmiro: With a system set to English or Dutch it works fine, so you may have to tweak the function a bit to accomodate for the Catalan language. A few examples would help to understand your exact issue

		jmmiro, Aprodisca Oct 9, 2018
Rectifico mi comentario anterior funciona bien dependiendo de la configuraciÃ³n de la hora del sistema

		Menno van Beek, Van Beek Zakelijke Software Oct 9, 2018
@jmmiro: With a system set to English or Dutch it works fine, so you may have to tweak the function a bit to accomodate for the Catalan language. A few examples would help to understand your exact issue

		Menno van Beek, Van Beek Zakelijke Software Oct 9, 2018
@jmmiro: in which setting is it then? How is a timeentry in that language look like?

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

TimeCorrect ( TimeEntry )

Comments

Support this website.

Support this website.