Time formatting for hours over 24

…In this worksheet called powers over 24, we're about to tabulate the length…of programs in column B, similar set up in columns D, and E, also.…If we put in a formula in cell B nine, then, the…fastest way to do this probably would be with the auto-sum button, found…either on the formulas tab in the ribbon off to the left…side or here on the hung tab off to the right auto sum.…Click auto sum, you see the intended area, looks good,…we press enter but we just know that answer's incorrect.…In fact it's smaller than many of the enters.…

Now oddly enough if we highlight these cells and look…in the status bar, and if you do have some displayed…in the status bar, most people do, you do see…a total down there, it says 26 hours and 59 minutes.…Now this says, two hours and 59 minutes.…Right away maybe the wheels are clicking.…That happens to be two hours and 59 minutes beyond the 24 hour frame.…And by the way, if you do not see any total whatsoever…in the status bar, a simple right click in the status bar.…They do want to have the, I think most…