Subtract minutes from hours formula

[Crowland775]

I am having an issue trying to find a formula to subtract minutes from hours based off the formulas I have used to sum the time remaining.

I am trying to sum the times in E5 and E6 into cell E3.

B5: =LEFT(B3,FIND(":",B3)-1)
C5: =LEFT(C3,FIND(":",C3)-1)
D5: =LEFT(D3,FIND(":",D3)-1)
E5: =SUM(D5*1)-(B5*1)
B6: =RIGHT(B3,2)
C6: =RIGHT(C3,2)
D6: =RIGHT(D3,2)
E6: =SUM(D6*1)-(B6*1)

E3: ?????

MX Projection.xlsx
	A	B	C	D	E
1	N888WU	Current time	3000-HR Start	3000-HR End	Time Remaining
2	N888WU	Current time	3000-HR Start	3000-HR End	Time Remaining
3	Time Value:	14618:49	13401:41	16415:36
4
5	Hours:	14618	13401	16415	1797
6	Minutes:	49	41	36	-13
Sheet3

Cell Formulas
Range	Formula
B5:D5	B5	=LEFT(B3,FIND(":",B3)-1)
E5:E6	E5	=SUM(D5*1)-(B5*1)
B6:D6	B6	=RIGHT(B3,2)

 

[Crowland775]

Can anyone help me out with this Formula so that E3 will equal 1796:47?

 

[Phuoc]

Try this

Book1
	A	B	C	D	E
1	N888WU	Current time	3000-HR Start	3000-HR End	Time Remaining
2	N888WU	Current time	3000-HR Start	3000-HR End	Time Remaining
3	Time Value:	14618:49	13401:41	16415:36	1796:47
Sheet1

Cell Formulas
Range	Formula
E3	E3	=SUBSTITUTE(TEXT(DOLLARFR(DOLLARDE(SUBSTITUTE(D3,":","."),60)-DOLLARDE(SUBSTITUTE(B3,":","."),60),60),"0.00"),".",":")

 

[Crowland775]

Try this

Book1
	A	B	C	D	E
1	N888WU	Current time	3000-HR Start	3000-HR End	Time Remaining
2	N888WU	Current time	3000-HR Start	3000-HR End	Time Remaining
3	Time Value:	14618:49	13401:41	16415:36	1796:47
Sheet1

Cell Formulas
Range	Formula
E3	E3	=SUBSTITUTE(TEXT(DOLLARFR(DOLLARDE(SUBSTITUTE(D3,":","."),60)-DOLLARDE(SUBSTITUTE(B3,":","."),60),60),"0.00"),".",":")

THANK YOU, THANK YOU, THANK YOU!!!! IT WORKED!!! You helped me out so much.