Subtracting a time from a day and 2 days prior

[flucky07]

I have having one heck of a time finding out how to subtract time.
have tried so many different times, hopefully someone can help me out

Here is what i want to do
I have a date and time 06/07/06 08:46:00 am
Also have a date and time 06/08/06 11:52:00 am

I want to be able to subtract those times and be able to get an hh:m
format...

Here is the spreadsheet i want to use...

The value under 6/8/06 i want to subtract by the value of 6/7/06 to ge
hh:mm format

Eri

+-------------------------------------------------------------------
|Filename: excel.jpeg
|Download: http://www.excelforum.com/attachment.php?postid=4882
+-------------------------------------------------------------------

 

[Guest]

=(EndDate-StartDate) and format cell as CUSTOM=>[h]:mm

[] are required round the H to ensure Excel doesn't convert to "days".

HTH

 

[Bob Phillips]

Subtract the earlier from the later and format as [h]:mm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)