Create three hidden fields -- one for hours, one for minutes, and one for total number of seconds
Subtracting the two times yields a total number of seconds. Put that value in the seconds field. Divide that value by 3600. That gives you total hours with a decimal. Use the INT function to strip the decimal off. Put that value in the hours field. Subtract the product of the value in the hours field and 3600 from the total number of seconds. Then divide by 60. That's your number of minutes. Put that in the minutes field. Concatenate the hours field, a ":", and the minutes field, and you're done. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abdul Baytops Sent: Friday, June 27, 2008 9:19 AM To: [email protected] Subject: Calculating Time ** Hello Listers I know its Friday but I have a question regarding calculating the time in a Remedy Form. I have 2 Date/Time fields on a form in which I need to figure out how to determine the time difference from Field A & Field B in total time but the format I need the result in is hours and minutes. Example: 11:00 am (Field A) 2:05 pm (Field B) = 3 hours 5 minutes (Field C) Thanks in advance Abdul Remedy 7.1 SQL Server 2005 Windows server 2003 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
