> Any thoughts? Yeah I foresee issues :-)
But to get started you could do something like this to get your numbers formatted like you said. <cfset thenumber = "123" /> <cfset thenumber = left(numberformat(thenumber, "0000"), 2) & ":" & right(numberformat(thenumber, "0000"), 2) /> <cfoutput>#timeformat(thenumber, 'hh:mm')#</cfoutput> That should give you 01:23 The problem with that would be that a number like 20 would get converted to 00:20 and when timeformatted, it would convert to 12:20 ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Jim H [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 10:41 AM To: CF-Talk Subject: Time Question I am building a hockey stats application. I need to be able to allow the user to enter in any 2-4 numbers. I then need a way to convert the 2-4 numbers into a time format. Will the TimeFormat function do this? EX: 24 = 00:24 132 = 1:32 I also need to subtract that time from another time to get the correct score time. EX: 12:00 - 3:00 = 9:00 12:00 - 3:32 = 8:28 Any thoughts? Thanks in advance! Jim H ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
