date & time difference calculation

[David Morrison - Corporate]

Lorry,

If you get 14 minutes instead of 15 minutes, you probably have a rounding problem, due to the seconds.

David Morrison
McBride Electric

 -----Original Message-----
From: 	Lorry Litman [mailto:LLitman@exchange.hsc.mb.ca] 
Sent:	Monday, May 17, 2004 8:30 AM
To:	'Chris Sharman'; PowerH List
Subject:	RE: date & time difference calculation

 << Message: Re: date & time difference calculation >> Thank-you for your reply.

I neglected to mention that I need to store the result in format YYMMDDHHMM.
In trying the code below I seem to be getting incorrect results. I'll have
to play with it a little more as I'm not that familiar with these functions.

As an example,
 difference between 21-jan-1999-10:15 and 20-jan-1999-14:00 results in 2735
(27 hrs, 35 min) when I expected a result of 2015 (20 hrs, 15 min),
 difference between 10:15 and 10:00 comes up as 14 instead of 15.

Thanx Lorry.



-----Original Message-----

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.