RE: Time Question

[Doug Arthur]

This does exactly what you're looking for:

<cfset t1 = "12:00" />
<cfset t2 = "10:24" />
<cfset diff = DateDiff("s", t2, t1) />
<cfset remaining = DateAdd("s", diff, t1) />
<cfoutput>#TimeFormat(remaining, "hh:mm")#</cfoutput>

- Doug

-----Original Message-----
From: Josh Nathanson [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 02, 2007 1:38 PM
To: CF-Talk
Subject: Re: Time Question

> You should be able to do DateAdd to do this -

.....or just use DateDiff as Ian said.

-- Josh



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282734
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4