CFLib.org – Common Function Library Project

Description:
Converts h:mm:ss or h:mm strings to hours rounded to tenths, used in my case for legal time billing.

Return Values:
Returns a string.

Example:

<cfset HoursInTenths = ConvertHours("6:33:06")>
<cfoutput>#Variables.HoursInTenths#</cfoutput>

Parameters:

Full UDF Source:

<cfscript>
/**
 * Function that returns legal billing time from standard time format.
 * 
 * @param hourString 	 A string containing the number of hours, minutes, and seconds in the format: H:MM:SS. (Required)
 * @return Returns a string. 
 * @author Joe (&#106;&#99;&#114;&#97;&#118;&#101;&#110;&#64;&#97;&#107;&#105;&#110;&#103;&#117;&#109;&#112;&#46;&#99;&#111;&#109;) 
 * @version 1, July 3, 2002 
 */
function ConvertHours(HourString) {
	var HourWords = "";
	var MinuteVal = Round(val(listGetAt(HourString,2,":"))/6);
	var HourVal = listFirst(hourString,":");
	
	if(len(HourVal) is 1) {
		if(HourVal is "0") HourWords = '0.';
		else HourWords = HourVal & '.';
	} else HourWords = HourVal & '.';
	
	HourWords = HourWords & MinuteVal;
	return HourWords;
}
</cfscript>