TimeAsDecimal ( xTime )

Convert normal formatted time ( hh:mm:ss ) into decimal time ( x,xx )

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

Michael Bijnens
freelance developer
/

Sample input:

TimeAsDecimal ( 01:19:48 )

Sample output:

1,33

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

/* ============================================
#
# Purpose:			convert normal time format ( hh:mm:ss ) to decimal time ( x,x )
#
# Arthor:				Michael Bijnens
# Creation date:		01/01/2014
#
# Note:				I also developed another convertor ( DecimalAsTime )
#
=============================================*/


Let (
	[ 
		hours = Hour ( xTime ) ;
                divisor = ( 60 ) ;
		minutes = Minute ( xTime ) + ( Seconds ( xTime ) / divisor )
	] ;
		Round ( 
				hours + (minutes / divisor) ; 
		2
		)
)

This custom function converts normal formatted time ( hh:mm:ss ) into decimal time ( x,xx ).
I also developed another convertor ( DecimalAsTime ).

Comments

		markus schneider, switzerland May 15, 2014
in the 'define var' - section, the last ';' has to be removed (after 'minutes')

		Michael Bijnens, Belgium May 16, 2014
@ Markus Schneider: Thanks for the comment.. I have corrected it !

		Mr. Pascal Goossens, Bastogne Jul 19, 2017
Merci beaucoup, je vais le tester dÃ¨s demain

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

TimeAsDecimal ( xTime )

Comments

Support this website.

Support this website.