Format your Cells so the time shows up as HH:MM:SS - there is an option
for this: Select all of your Cells and/or columns - then go to the
MENUBAR and Select FORMAT - CELLS - Number - then under "Category"
Select TIME and then under TYPE select something that looks like
13:30:55 and this should work for you. There might be another way to do
it under CUSTOM - but this should work for you.
If your values are as follows:
A---------B---------C-------D
Start-----End------Start----End
Your formula should look something like this:
=(B1-A1)+(D1-C1), and so on and so on
You do not need the () around the (B1-A1), etc. I think it makes it
easier to read.
Don't forget to format the column or cells where your final results are
displayed.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=500985