Solved

Outlook 2007 Calendar - Add up time spent on separate events

Posted on 2014-03-29
2
1,072 Views
Last Modified: 2014-04-24
I've just begun to use the Calendar in Outlook 2007 and have been pleasantly surprised by the amount of detail I can add to a Scheduled event.

I've created separate Calendars for each of my Service Techs and am now using them to keep track of jobs scheduled during the work week.  Start Time and End Time are of great benefit as I use those entries for calculating payroll.  However, since a tech can travel to and complete several different jobs in a single day, I spend a lot of time at the end of the week opening events and manually calculating the time spent on each single scheduled event.

Is there a way for Outlook to calculate/export "Start Time" and "End Time" entries so that a running total of hours spent working on all scheduled events for the day/week can be tracked?  This would be a tremendous timesaver.
0
Comment
Question by:baleman2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Expert Comment

by:Patrick Bogers
ID: 39964785
Hi

Worktimer could be what you are looking for, this example https://worktimer.nl/ is a dutch way but i am sure there are many more when you google for "worktimer for outlook"
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 39966755
Hi, baleman2.

You can accomplish this with a really simple macro.  Something like

Sub CalculateTotalEventTime()
    Dim olkApt As Outlook.AppointmentItem, dblTot As Double
    For Each olkApt In Application.ActiveExplorer.Selection
        dblTot = dblTot + olkApt.Duration
    Next
    dblTot = dblTot / 60
    MsgBox "The selected appontments total to " & dblTot & " hours.", vbInformation + vbOKOnly, "Calculate Total Event Time"
End Sub

Open in new window


This macro reads through all the selected appointment and sums the Duration field.  It then displays a dialog-box showing you the total time in hours.  All you need to do is select the appointments you want to sum and run the macro.

Here's how you'd add the macro to Outlook.

1.  Start Outlook
2.  Press ALT+F11 to open the Visual Basic editor
3.  If not already expanded, expand Microsoft Office Outlook Objects
4.  If not already expanded, expand Modules
5.  Select an existing module (e.g. Module1) by double-clicking on it or create a new module by right-clicking Modules and selecting Insert > Module.
6.  Copy the code from the Code Snippet box and paste it into the right-hand pane of Outlook's VB Editor window
7.  Click the diskette icon on the toolbar to save the changes
8.  Close the VB Editor
0

Featured Post

SendBlaster Pro 4 - Bulk Email Sending Software

SendBlaster 4 Pro - Best Bulk Emailing Sending Software
Automatic Subscribe / Unsubscribe Processing
Great for Newsletters & Mass Mailings
Optional HTML & Text Composition
Integration with Google Features
Built in Spam Score Checking
Free Professional Templates - Feature Packed!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question