Is this using the SUBSTR function in my active link as well... Abdul Baytops -Director of Business Operations Digital Foundation Corporation Office: 301-283-3410 Mobile: 240-346-4628 Web: www.thedigitalcorp.com
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Friday, June 27, 2008 10:50 AM To: [email protected] Subject: Re: Calculating Time And if they are in fact date/time fields...and you have the possibility of more than 24 hours...you might want to add another for 'days'...and limit hours to 23...:) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, June 27, 2008 8:29 AM To: [email protected] Subject: Re: Calculating Time b - a = c c is seconds c mod 60 = seconds c / 60 = minutes with a remainder in seconds c / 3600 = hours with a remainder in seconds drop the remainder for minutes and hours, then you can create a string with the format of hours:minutes:seconds Axton Grams On Fri, Jun 27, 2008 at 10:18 AM, Abdul Baytops <[EMAIL PROTECTED]> wrote: > ** > > 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" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
