** 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:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, November 08, 2013 11:11 AM To: arslist@ARSLIST.ORG 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 <kathymorris...@aol.com> 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:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Thursday, November 07, 2013 3:27 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, November 07, 2013 3:26 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Thursday, November 07, 2013 2:17 PM To: arslist@ARSLIST.ORG 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
