date & time difference calculation
Joe Boyle
joeboyle_adt@hotmail.com
Mon, 17 May 2004 17:35:11 +0100
<html><div style='background-color:'><DIV class=RTE>
<P>Hi Lorry,</P>
<P>what is the syntax that you are using to get the difference ?<BR><BR></P></DIV>
<DIV></DIV>>From: Lorry Litman <LLitman@exchange.hsc.mb.ca>
<DIV></DIV>>To: "'Chris Sharman'" <chris.sharman@ccagroup.co.uk>, PowerH List <powerh-l@lists.sowder.com>
<DIV></DIV>>Subject: RE: date & time difference calculation
<DIV></DIV>>Date: Mon, 17 May 2004 10:29:35 -0500
<DIV></DIV>>
<DIV></DIV>>Thank-you for your reply.
<DIV></DIV>>
<DIV></DIV>>I neglected to mention that I need to store the result in format YYMMDDHHMM.
<DIV></DIV>>In trying the code below I seem to be getting incorrect results. I'll have
<DIV></DIV>>to play with it a little more as I'm not that familiar with these functions.
<DIV></DIV>>
<DIV></DIV>>As an example,
<DIV></DIV>> difference between 21-jan-1999-10:15 and 20-jan-1999-14:00 results in 2735
<DIV></DIV>>(27 hrs, 35 min) when I expected a result of 2015 (20 hrs, 15 min),
<DIV></DIV>> difference between 10:15 and 10:00 comes up as 14 instead of 15.
<DIV></DIV>>
<DIV></DIV>>Thanx Lorry.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>
<DIV></DIV>>This e-mail and/or any documents in this transmission is intended for the address(s) only and may contain legally privileged or confidential information. Any unauthorized use, disclosure, distribution, copying or dissemination is strictly prohibited. If you receive this transmission in error, please notify the sender immediately and return the original.
<DIV></DIV>><< message3.txt >>
<DIV></DIV></div></html>