Difference in time

[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

[Sandy Mann]

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
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

"pcor" <pcor@discussions.microsoft.com> wrote in message
news:3986723A-1417-4B37-9488-2558111E88D3@microsoft.com...
> 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

[Duke Carey]

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

[pcor]

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
> sandymann2@mailinator.com
> Replace@mailinator.com with @tiscali.co.uk
>
> "pcor" <pcor@discussions.microsoft.com> wrote in message
> news:3986723A-1417-4B37-9488-2558111E88D3@microsoft.com...
> > 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
>
>
>

[pcor]

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