software

What do I have to do to find out how many hours and minutes between the 2
following date/times
25 Feb 2006 0908 AM
27 Feb 2006 0200 PM
I have tried some formatting but never got the right answer
Thanks in advance
PCOR

You don't say what formtting you have tried but assuming that the date amp;
time is in the same cell, I got 52:52 by formatting the subtraction cell as
[h]:mm--
HTH

Sandy
with @tiscali.co.uk

quot;pcorquot; gt; wrote in message
...
gt; What do I have to do to find out how many hours and minutes between the 2
gt; following date/times
gt; 25 Feb 2006 0908 AM
gt; 27 Feb 2006 0200 PM
gt; I have tried some formatting but never got the right answer
gt; Thanks in advance
gt; PCOR
Check Chip Pearson's site

www.cpearson.com/excel/datetime.htm#WorkHoursquot;pcorquot; wrote:

gt; What do I have to do to find out how many hours and minutes between the 2
gt; following date/times
gt; 25 Feb 2006 0908 AM
gt; 27 Feb 2006 0200 PM
gt; I have tried some formatting but never got the right answer
gt; Thanks in advance
gt; PCOR

Thanks again..I did finally get it goingquot;Sandy Mannquot; wrote:

gt; You don't say what formtting you have tried but assuming that the date amp;
gt; time is in the same cell, I got 52:52 by formatting the subtraction cell as
gt; [h]:mm
gt;
gt;
gt; --
gt; HTH
gt;
gt; Sandy
gt;
gt; with @tiscali.co.uk
gt;
gt; quot;pcorquot; gt; wrote in message
gt; ...
gt; gt; What do I have to do to find out how many hours and minutes between the 2
gt; gt; following date/times
gt; gt; 25 Feb 2006 0908 AM
gt; gt; 27 Feb 2006 0200 PM
gt; gt; I have tried some formatting but never got the right answer
gt; gt; Thanks in advance
gt; gt; PCOR
gt;
gt;
gt;

Thanks

quot;Duke Careyquot; wrote:

gt; Check Chip Pearson's site
gt;
gt; www.cpearson.com/excel/datetime.htm#WorkHours
gt;
gt;
gt; quot;pcorquot; wrote:
gt;
gt; gt; What do I have to do to find out how many hours and minutes between the 2
gt; gt; following date/times
gt; gt; 25 Feb 2006 0908 AM
gt; gt; 27 Feb 2006 0200 PM
gt; gt; I have tried some formatting but never got the right answer
gt; gt; Thanks in advance
gt; gt; PCOR