Help determining elapsed time between two dates and times in excel 2010 using military time

[icepole4]

A	B	C	D	E
Entrance Date	Entrance Time	Depart Date	Depart Time	elapsed time
12/31/2013	22:52	1/2/2014	01:35	-21:15
12/4/2013	11:16	12/5/2013	16:55	05:40
12/4/2013	13:59	12/5/2013	14:47	00:89
8/12/2013	19:24	8/13/2013	20:03	00:80
9/15/2013	03:45	9/16/2013	04:00	00:56
9/18/2013	18:51	9/19/2013	18:57	00:07
2/26/2013	14:34	2/27/2013	14:29	-00:04
6/19/2013	16:12	6/20/2013	14:41	-01:70
12/4/2013	19:05	12/5/2013	17:00	-02:04

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

In the table above I am trying to calculate the elapsed time between entrance and departure in hours and minutes. To calculate I entered the following formula in the elapsed time column

=((C2+D2)-(A2+B2))

Seems like a rock solid formula; however as you can see from my elapsed time outcomes; it's not coming out correctly. The formula is seemingly not even taking the date into account even though its being added to the time.

The formatting of the Date fields is, m/dd/yyyy
The formatting of the time fieds is, 00":"00
Formatting of the elapsed time field is, 00":"00

Is the military time throwing excel off...is my formatting wrong? Any help would be appreciated.

 

[Weazel]

try something like

E2=(C2+D2)-(A2+B2) formatted as [h]:mm

 

[icepole4]

try something like

E2=(C2+D2)-(A2+B2) formatted as [h]:mm

Just tried it...instead of a number I now get ########################

Thanks for the help though, hopefully someone out there can help because I am stumped.

 

[Weazel]

I'm not sure but it seems to be working ok for me

E2=(C2+D2)-(A2+B2) formatted as [h]:mm

Row\Col	A​	B​	C​	D​	E​
1​	Entrance Date	Entrance Time	Depart Date	Depart Time	elapsed time
2​	12/31/2013​	22:52​	1/2/2014​	1:35​	26:43​
3​	12/4/2013​	11:16​	12/5/2013​	16:55​	29:39​
4​	12/4/2013​	13:59​	12/5/2013​	14:47​	24:48​
5​	8/12/2013​	19:24​	8/13/2013​	20:03​	24:39​
6​	9/15/2013​	3:45​	9/16/2013​	4:00​	24:15​
7​	9/18/2013​	18:51​	9/19/2013​	18:57​	24:06​
8​	2/26/2013​	14:34​	2/27/2013​	14:29​	23:55​
9​	6/19/2013​	16:12​	6/20/2013​	14:41​	22:29​
10​	12/4/2013​	19:05​	12/5/2013​	17:00​	21:55​

<tbody>
</tbody>