Subtracting a time from a day and 2 days prior

F

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
+-------------------------------------------------------------------
 
T

Toppers

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

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

HTH
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top