#TimeFormat(the_time_in_hours/24, "HH:mm")# I use this all the time to format things like elapsed time in HH:mm:ss. You might want to be careful if the value goes over 24 hours, howerver. If you have a value of 36.5, for example, I believe CF would then format it to 12:30.
----- Original Message ----- From: "jon hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 10:32 AM Subject: displaying time in hours > 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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