Help

golfjunkie

New Member
Joined
Apr 21, 2010
Messages
4
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>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
That formula is syntactically incorrect. Please copy the formula from the Formula Bar in Excel and paste it into your reply.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,563
Messages
6,114,329
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top