** 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
