Difference in time
 

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

Difference in time
 

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

with @tiscali.co.uk

"pcor" wrote in message
...
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

Difference in time
 

Check Chip Pearson's site

http://www.cpearson.com/excel/datetime.htm#WorkHours


"pcor" wrote:

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

Difference in time
 

Thanks again..I did finally get it going


"Sandy Mann" wrote:

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

with @tiscali.co.uk

"pcor" wrote in message
...
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

Difference in time
 

Thanks

"Duke Carey" wrote:

Check Chip Pearson's site

http://www.cpearson.com/excel/datetime.htm#WorkHours


"pcor" wrote:

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