<div>
I'm splitting the points here, because while neither solution perfectly solved my problem, both helped point the way. It turned out that (for reasons I don't understand) my calculations were, indeed, throwing text values. So I was able to get my calculations to work by using the values function in the calculations.<br />
<br />
Thanks for the insights.
</div>


I'm splitting the points here, because while neither solution perfectly solved my problem, both helped point the way. It turned out that (for reasons I don't understand) my calculations were, indeed, throwing text values. So I was able to get my calculations to work by using the values function in the calculations.

Thanks for the insights.

<div>
<div class="content wysiwyg-content">
With previous EE assistance and some creative calculations I have managed to create the attached time sheet with calculations for two daily blocks of hours. Everything works but the cumulative calculation on row 31 column D. As is clear from the calculation I am simply trying to sum the cumulative hours from Monday and Tuesday, but for some reason the calculation is showing zero even though there are obviously values in the cells being calculated. Obviously I hope to repeat similar calculations throughout the worksheet, but I first need to understand what I am doing wrong with the time value calculations.<br />
<br />
Any assistance will be appreciated.<br />
<br />
Thanks.
</div>
</div>


With previous EE assistance and some creative calculations I have managed to create the attached time sheet with calculations for two daily blocks of hours. Everything works but the cumulative calculation on row 31 column D. As is clear from the calculation I am simply trying to sum the cumulative hours from Monday and Tuesday, but for some reason the calculation is showing zero even though there are obviously values in the cells being calculated. Obviously I hope to repeat similar calculations throughout the worksheet, but I first need to understand what I am doing wrong with the time value calculations.

Any assistance will be appreciated.

Thanks.

Time Sheet Calculation

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.