** Thank you! I really think it's time for a vacation I had the query in reverse J
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Friday, November 08, 2013 11:17 AM To: [email protected] Subject: Re: Time Measurement ** 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]] 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]] 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_ _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"
