You need to put in the order of operation though, otherwise it will divide first (Field 1 - Field 2) / 60
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Friday, July 27, 2007 10:21 AM To: [email protected] Subject: Re: Minutes between two date / Time fields ** Without knowing which field has the later time how does this sound: Field 1 - Field 2 / 60 HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ames Sent: Friday, July 27, 2007 1:16 PM To: [email protected] Subject: Minutes between two date / Time fields If I wasn't in a hurry and swamped I would figure this out on my own, but hopefully someone has done this and has a quick answer. I just need to calculate the number of minutes between two DateTime fields and put it in another field. It sounds simple but I keep getting the wrong values. Has anyone done this that could post the formula? __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
