i use this for hr min output :
<cfset totaltime =
"<b>" & Fix((DateDiff('n', StartTime, StopTime)/60)) & "</B> HR " &
"<b>" & NumberFormat((DateDiff('n', StartTime, StopTime) MOD 60),'00') & "</B> MIN">
adjust to taste.
gl,
alex
-----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;"
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
