How to Convert a Numeric Value to HH:MM:SS Time FormatID: Q101022 2.50 2.50a | 2.00 2.50 2.50a WINDOWS | MS-DOS kbprg The information in this article applies to:
To convert a number of hours expressed as a numeric value to a time string of the form "HH:MM:SS", you can use the following user-defined function (UDF): * NTOT(<expN>) * Returns a string in the form "HH:MM:SS". * <expN> is a number of hours expressed as a numeric value between * 0 and 24. If <expN> is negative or greater than 24, the null * string is returned. FUNCTION NTOT PARAMETERS number PRIVATE hours,minutes,seconds,hourstring,minutestring,secondstring IF number < 0 OR number > 24 && Error checking RETURN "" ENDIF * Break number down into hour, minute, and second values hours=INT(number) minutes=INT((number-hours)*60) seconds=( ((number-hours)*60) - minutes ) * 60 * Convert values to strings and pad with leading zeros if necessary hourstring=IIF( hours>9, LTRIM(STR(hours)), "0"+LTRIM(STR(hours)) ) minutestring=IIF( minutes > 9, LTRIM(STR(minutes)), "0"+LTRIM(STR(minutes)) ) secondstring=IIF(seconds > 9, LTRIM(STR(seconds)), "0"+LTRIM(STR(seconds)) ) * Return completed string in the form "HH:MM:SS" RETURN ( hourstring +':' + minutestring + ':' + secondstring ) Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a 2.x TTON KBCategory: kbprg KBSubcategory: FxprgGeneral Keywords : FxprgGeneral Version : 2.50 2.50a | 2.00 2.50 2.50a Platform : MS-DOS WINDOWS |
Last Reviewed: April 30, 1996 |