Jeez... must I say it again? CRAP 8^)
Thanks for the correction. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Everett, Al [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 6:58 AM > To: CF-Talk > Subject: RE: Time calculation > > > I think you want integer division: "\" > > > -----Original Message----- > > From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 26, 2002 8:26 PM > > To: CF-Talk > > Subject: RE: Time calculation > > > > > > Crap. > > > > Change all of the "LTE"s to "GTE"s and all of the "MOD"s to > > "/" (divided > > by). That'll teach me not to test code. > > > > -- > > Mosh Teitelbaum > > evoch, LLC > > Tel: (301) 625-9191 > > Fax: (301) 933-3651 > > Email: [EMAIL PROTECTED] > > WWW: http://www.evoch.com/ > > > > > > > -----Original Message----- > > > From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, September 26, 2002 6:32 PM > > > To: CF-Talk > > > Subject: RE: Time calculation > > > > > > > > > DateDiff() by itself is not enough. It can tell you the > > > difference in days > > > OR hours OR ..., but not all combined. The following (untested) > > > code should > > > do what you want. My apologies if it doesn't 8^). > > > > > > <!--- Get difference in seconds ---> > > > <CFSET diffSeconds = DateDiff("s", start, end)> > > > > > > <!--- Initialize display vars ---> > > > <CFSET dspDays = 0> > > > <CFSET dspHours = 0> > > > <CFSET dspMinutes = 0> > > > <CFSET dspSeconds = 0> > > > > > > <!--- Get the number of days and subtract them from diffSeconds ---> > > > <CFSET secondsInDay = 60 * 60 * 24> > > > <CFIF diffSeconds LTE secondsInDay> > > > <CFSET dspDays = diffSeconds MOD secondsInDay> > > > <CFSET diffSeconds = diffSeconds - (secondsInDay * dspDays)> > > > </CFIF> > > > > > > <!--- Get the number of hours and subtract them from > > diffSeconds ---> > > > <CFSET secondsInHour = 60 * 60> > > > <CFIF diffSeconds LTE secondsInHour> > > > <CFSET dspHours = diffSeconds MOD secondsInHour> > > > <CFSET diffSeconds = diffSeconds - (secondsInHour * dspHours)> > > > </CFIF> > > > > > > <!--- Get the number of minutes and subtract them from > > diffSeconds ---> > > > <CFSET secondsInMinute = 60> > > > <CFIF diffSeconds LTE secondsInMinute> > > > <CFSET dspMinutes = diffSeconds MOD secondsInMinute> > > > <CFSET diffSeconds = diffSeconds - (secondsInMinute * > > dspMinutes)> > > > </CFIF> > > > > > > <!--- Get number of seconds ---> > > > <CFSET dspSeconds = diffSeconds> > > > > > > <!--- Display in day:hour:minute:second format ---> > > > <CFOUTPUT> > > > #dspDays#:#dspHours#:#dspMinutes#:#dspSeconds# > > > </CFOUTPUT> > > > > > > -- > > > Mosh Teitelbaum > > > evoch, LLC > > > Tel: (301) 625-9191 > > > Fax: (301) 933-3651 > > > Email: [EMAIL PROTECTED] > > > WWW: http://www.evoch.com/ > > > > > > > > > > -----Original Message----- > > > > From: John Gedeon [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, September 26, 2002 4:45 PM > > > > To: CF-Talk > > > > Subject: Time calculation > > > > > > > > > > > > I have two date and time fields, start and end. I want find the > > > > difference > > > > and i want to display the difference as days:hrs:mins:secs what > > > > is the best > > > > way to do that... ? > > > > > > > > Right now i use hour minute and second (built in functions) and > > > > those work > > > > find for differences less than one day but they do not display > > > > the correct > > > > amount of hours for differences longer than 1 day... > > > > any suggestions > > > > > > > > <>< Proverbs 3:5 "Trust in the Lord with all your heart > > and lean not on > > > > your own understanding;" > > > > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists