Re: time calculation problem
Posted by John ... on 07. September 2009

On Mon, 7 Sep 2009 21:27:01 -0700, reportyemi

Thank you guys. The formula worked in minutes as john mentioned. But Al's
previous formula though it didnot work gave me the format i wanted (hr:min).
So now i want a Al's format and Johns accuracy .

=Format(((DateDiff("n",startTime,endTime)+ 1440) Mod 1440)/1440, "hh:nn")

         John W. Vinson [MVP]