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"
