software

Hi, using Excel 2002 here.

I have 2 cells which are each formatted as quot;mm/dd/yy hh:mmquot; . I am trying to
get the number of hours:minutes between them. Please note that there can be
several days in between. How can I do this?

Thank you in advance

Gary
Subtract one from the other, and format as [h]:mm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Gary Hquot; gt; wrote in message
...
gt; Hi, using Excel 2002 here.
gt;
gt; I have 2 cells which are each formatted as quot;mm/dd/yy hh:mmquot; . I am trying
to
gt; get the number of hours:minutes between them. Please note that there can
be
gt; several days in between. How can I do this?
gt;
gt; Thank you in advance
gt;
gt; Gary
gt;
gt;