Subtracting a time from a day and 2 days prior
 

I have having one heck of a time finding out how to subtract time. I
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:mm
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 get
hh:mm format

Eric


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

--
flucky07
------------------------------------------------------------------------
flucky07's Profile: http://www.excelforum.com/member.php...o&userid=33733
View this thread: http://www.excelforum.com/showthread...hreadid=551558

Subtracting a time from a day and 2 days prior
 

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

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

HTH

"flucky07" wrote:


I have having one heck of a time finding out how to subtract time. I
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:mm
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 get
hh:mm format

Eric


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

--
flucky07
------------------------------------------------------------------------
flucky07's Profile: http://www.excelforum.com/member.php...o&userid=33733
View this thread: http://www.excelforum.com/showthread...hreadid=551558

Subtracting a time from a day and 2 days prior
 

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)

"flucky07" wrote in
message ...

I have having one heck of a time finding out how to subtract time. I
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:mm
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 get
hh:mm format

Eric


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

--
flucky07
------------------------------------------------------------------------
flucky07's Profile:
http://www.excelforum.com/member.php...o&userid=33733
View this thread: http://www.excelforum.com/showthread...hreadid=551558