And Hours is an integer field? Try (($End Date$ - $Start Date$) /3600)
order of operations stated that it would have done the divide before the subtract.... On Fri, Nov 8, 2013 at 9:13 AM, Kathy Morris <[email protected]> wrote: > ** > > ** > > Oops there is a typo… > > > > set field ‘Hours’ with the output of ($End Date$ - $Start Date$ /3600) on > modify > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *LJ LongWing > *Sent:* Friday, November 08, 2013 11:11 AM > > *To:* [email protected] > *Subject:* Re: Time Measurement > > > > ** > > Kathy, > > You may want to put $Start Date$ into an Int field before you do the > /3600.....but in general your setfield doesn't make allot of sense. > > > > On Fri, Nov 8, 2013 at 8:55 AM, Kathy Morris <[email protected]> > wrote: > > ** > > ** > > I had created an active link to set a field Hours with ($End Date$ = > $Start Date$ /3600) on modify. > > The error message displays “incompatible data types for arithmetic > operation.” > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Reiser, John J > *Sent:* Thursday, November 07, 2013 3:27 PM > *To:* [email protected] > *Subject:* Re: Time Measurement > > > > ** > > Make that 3600 > > > > Thank you, > > --- > John J. Reiser > Remedy Developer/Administrator > > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:[email protected] <[email protected]>] *On Behalf Of *Grooms, > Frederick W > *Sent:* Thursday, November 07, 2013 3:26 PM > *To:* [email protected] > *Subject:* EXTERNAL: Re: Time Measurement > > > > ** > > If you take and subtract 1 date from the other you will get total seconds > between them. Divide by 60 to get total hours. > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:[email protected] <[email protected]>] *On Behalf Of *Kathy > Morris > *Sent:* Thursday, November 07, 2013 2:17 PM > *To:* [email protected] > *Subject:* Time Measurement > > > > ** > > Hi, > > > > In the midst of building workflow to translate the dates to hours. > > For example, I want to calculate the total hours between the “start date” > to the “end date” within a table. Any ideas on the best way to translate > this? I always struggle with the dates. > > > > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
