jon hall wrote: > I'm working with some time increments that were entered into the database > in decimal format. 1.5 is 1 hour 30 minutes... > > Can anyone think of a way to format 1.5 as 1:30, or .75 as :45, etc? >
Get the number after the decimal point, keep it as a fraction and multiply by 60. Append that result with the number before the decimal point and you've got it. Oliver Tupman Key Systems Geotechnical. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4