Difference in time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 &
time is in the same cell, I got 52:52 by formatting the subtraction cell as
[h]:mm


--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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
(e-mail address removed)
(e-mail address removed) 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...
 
Back
Top