> 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?
Take off the integer, then multiply the remaining decimal value by 60 - it should give you the minutes ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
