I'm trying to do a calculation using timestamps. All I need is the time difference between the two stamps. No need for the dates. example: (2009-08-07 02:16:34) - (2009-08-07 01:36:01) I just need "2:16:34" - "1:36:01" but do not know enough coldfusion to get it to display properly. What is the proper calculation to get it to show a total of "40:33"?
Use dateDiff("n", d1, d2) to calculate the difference in minutes. Then use basic math to convert the total number of minutes to hours:minutes format. http://livedocs.adobe.com/coldfusion/8/htmldocs/functions_c-d_28.html