Help

[golfjunkie]

I build a simple worksheet to determine how we are performing against our scheduled belt times. To get Excel to figure the difference between the scheduled and actual end time I used the following formula TEXT(b6-b7)”h:mm” which give me the difference in time. My problem is this. I was asked to add a daily, weekly and monthly total and I cannot get a viable total when there are negative number is the total of the text fields. How can I get the result I am trying to achieve?

<TABLE style="WIDTH: 515pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=682 border=0 x:str><COLGROUP><COL style="WIDTH: 143pt; mso-width-source: userset; mso-width-alt: 6948" width=190><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" span=6 width=82><TBODY><TR style="HEIGHT: 40.5pt; mso-height-source: userset" height=54><TD class=xl42 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 515pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 40.5pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" align=middle width=682 colSpan=7 height=54>Belt Time Tracking Sheet</TD></TR><TR style="HEIGHT: 21pt; mso-height-source: userset" height=28><TD class=xl23 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 21pt; BACKGROUND-COLOR: transparent" height=28>Week Ending 10/8</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Monday</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Tuesday</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Wednesday</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Thursday</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Friday</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Saturday</TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 2" height=32><TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Schedule End of 1st Batch</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.38958333333333334">9:21</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.36458333333333331">8:45</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.39652777777777781">9:31</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.44097222222222227">10:35</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl29 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 2" height=32><TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Actual End 1st Batch</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.42708333333333331">10:15</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.37291666666666662">8:57</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.39444444444444443">9:28</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.43333333333333335">10:24</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 1" height=32><TD class=xl44 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Minutes + or -</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(B3-B4,"h:mm")'>-0:54</TD><TD class=xl49 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(C3-C4,"h:mm")'>-0:12</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(D3-D4,"h:mm")'>0:03</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(E3-E4,"h:mm")'>0:11</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(F3-F4,"h:mm")'>0:00</TD><TD class=xl36 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(G3-G4,"h:mm")'>0:00</TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 2" height=32><TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Schedule End of 2nd Batch</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.60763888888888895">14:35</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.59444444444444444">14:16</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.625">15:00</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.64583333333333337">15:30</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 2" height=32><TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Actual End 2nd Batch</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.60833333333333328">14:36</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.63541666666666663">15:15</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.62361111111111112">14:58</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.65625">15:45</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 1" height=32><TD class=xl44 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Minutes + or -</TD><TD class=xl46 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(B6-B7,"h:mm")'>-0:01</TD><TD class=xl37 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(C6-C7,"h:mm")'>-0:59</TD><TD class=xl37 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(D6-D7,"h:mm")'>0:02</TD><TD class=xl45 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(E6-E7,"h:mm")'>-0:15</TD><TD class=xl37 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(F6-F7,"h:mm")'>0:00</TD><TD class=xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(G6-G7,"h:mm")'>0:00</TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 2" height=32><TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Schedule End of 3rd Batch</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.60486111111111118">14:31</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.62916666666666665">15:06</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl32 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 2" height=32><TD class=xl41 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Actual End 3rd Batch</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl31 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.63541666666666663">15:15</TD><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent" x:num="0.62361111111111112">14:58</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl32 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset; mso-outline-level: 1" height=32><TD class=xl44 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Minutes + or -</TD><TD class=xl47 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(B9-B10,"h:mm")'>0:00</TD><TD class=xl39 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(C9-C10,"h:mm")'>-0:44</TD><TD class=xl39 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(D9-D10,"h:mm")'>0:08</TD><TD class=xl39 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(E9-E10,"h:mm")'>0:00</TD><TD class=xl39 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(F9-F10,"h:mm")'>0:00</TD><TD class=xl40 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:fmla='=TEXT(G9-G10,"h:mm")'>0:00</TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset" height=32><TD class=xl43 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" height=32>Total Minutes + or -</TD><TD class=xl50 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext 1pt dashed; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: yellow" x:fmla='=TEXT(B5+B8+B11,"h:mm")' x:err="#VALUE!">#VALUE!</TD><TD class=xl50 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext 1pt dashed; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: yellow" x:fmla='=TEXT(C5+C8+C11,"h:mm")' x:err="#VALUE!">#VALUE!</TD><TD class=xl50 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext 1pt dashed; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: yellow" x:fmla='=TEXT(D5+D8+D11,"h:mm")'>0:13</TD><TD class=xl50 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext 1pt dashed; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: yellow" x:fmla='=TEXT(E5+E8+E11,"h:mm")' x:err="#VALUE!">#VALUE!</TD><TD class=xl50 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext 1pt dashed; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: yellow" x:fmla='=TEXT(F5+F8+F11,"h:mm")'>0:00</TD><TD class=xl50 style="BORDER-RIGHT: windowtext 1pt dashed; BORDER-TOP: windowtext 1pt dashed; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt dashed; BACKGROUND-COLOR: yellow" x:fmla='=TEXT(G5+G8+G11,"h:mm")'>0:00</TD></TR></TBODY></TABLE>

 

[Andrew Poulsom]

Welcome to MrExcel.

Please post the actual formula you are using.

 

[golfjunkie]

The formula I am using is TEXT(b6-b7)”h:mm”.

 

[Andrew Poulsom]

That formula is syntactically incorrect. Please copy the formula from the Formula Bar in Excel and paste it into your reply.

 

[golfjunkie]

=TEXT(B3-B4,"h:mm")

 

[Andrew Poulsom]

If I put that formula in B5 it returns #VALUE! (Excel 2003).

 

[Andrew Poulsom]

I see, Date 1904 selected. In B12 try:

=TEXT(SUMIF($A3:$A11,"Schedule End*",B3:B11)-SUMIF($A3:$A11,"Actual End*",B3:B11),"hh:mm")

copied across.

 

[golfjunkie]

Thanks, that works.