<div>
<div class="content wysiwyg-content">
I would like to summarize some data in a Calendar View.<br />
<br />
Specifically, I have 7 people who have time to track, and I have a data with the following Fields:<br />
<br />
Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Employee &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Time<br />
<br />
I would like to view the data in a calendar, that shows each employee and the number of hours summarized by date as well as the days total.<br />
<br />
I would appreciate any advice as to how to start on this. I am a fairly advanced Excel and do a fair amount of VBA programming in Access.<br />
<br />
I don't want to overthink this, so I am not really looking for code, but if someone knows of a template I could work with or something along those lines that would be great.
</div>
</div>


I would like to summarize some data in a Calendar View.

Specifically, I have 7 people who have time to track, and I have a data with the following Fields:

Date              Employee          Time

I would like to view the data in a calendar, that shows each employee and the number of hours summarized by date as well as the days total.

I would appreciate any advice as to how to start on this. I am a fairly advanced Excel and do a fair amount of VBA programming in Access.

I don't want to overthink this, so I am not really looking for code, but if someone knows of a template I could work with or something along those lines that would be great.

Create Calendar summarizing hours worked in Excel Spreadsheet

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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