Difference in time

P

pcor

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
 
P

pcor

Thanks again..I did finally get it going


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


--
HTH

Sandy
[email protected]
[email protected] with @tiscali.co.uk

pcor said:
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
Click to expand...
Click to expand...
 
Top