report of Available hours for a team of staff from OUtlook Calenda

Status
Not open for further replies.
K

kostas

Hi - I am looking at producing capacity reports from Outlook Calendars for a

number of Staff - Is this possible - i.e.

I have a distruibution list in Outlook Exchange with 10 employees.

Each employee has appointments added to their calendar by our Project

Operations person.

Each Employee also flags their own personal Time and Admin Time on different

days.

If we work on a Monday to Friday 8.30am to 5.30pm timespan - how can I

report on the number of hours Free as opposed to Busy/tentative for a Date

Range 1 day, 1 week, 1 month etc etc

Also can certain items be excluded form being calculated on?

Thanks KOSTAS
 
K

Ken Slovak - [MVP - Outlook]

You might want to try looking at the Utilities pages at www.slipstick.com

and see if anything is listed that meets your needs. If not what you want

can be done but it will require custom programming by someone who knows what

they are doing.

"kostas" <kostas> wrote in message

news:5313C48E-804C-4C19-9B87-706688CC0219@microsoft.com...
> Hi - I am looking at producing capacity reports from Outlook Calendars for
> a
> number of Staff - Is this possible - i.e.
> I have a distruibution list in Outlook Exchange with 10 employees.
> Each employee has appointments added to their calendar by our Project
> Operations person.
> Each Employee also flags their own personal Time and Admin Time on
> different
> days.
> If we work on a Monday to Friday 8.30am to 5.30pm timespan - how can I
> report on the number of hours Free as opposed to Busy/tentative for a
> Date
> Range 1 day, 1 week, 1 month etc etc

> Also can certain items be excluded form being calculated on?

> Thanks KOSTAS
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Kostas, see if VBOffice Reporter meets your needs. With it you can group by

the BusyStatus (free, tentative, etc.) and calculate the hours. For more

details see the link in my signature.

Best regards

Michael Bauer

Am Fri, 30 Apr 2010 01:14:02 -0700 schrieb kostas:


> Hi - I am looking at producing capacity reports from Outlook Calendars for


a
> number of Staff - Is this possible - i.e.
> I have a distruibution list in Outlook Exchange with 10 employees.
> Each employee has appointments added to their calendar by our Project
> Operations person.
> Each Employee also flags their own personal Time and Admin Time on


different
> days.
> If we work on a Monday to Friday 8.30am to 5.30pm timespan - how can I
> report on the number of hours Free as opposed to Busy/tentative for a


Date
> Range 1 day, 1 week, 1 month etc etc

> Also can certain items be excluded form being calculated on?

> Thanks KOSTAS
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
V Report Permission Exchange Server Administration 1
HarvMan Outlook 365 PST Report Using Outlook 1
T Report For Task Recurrance Outlook VBA and Custom Forms 4
D IMP.Note Versus REPORt.IPM.NOte Outlook VBA and Custom Forms 3
C Long List Of Outlook 2016/Outlook.com Bugs // Where To Report? Using Outlook 10
S Meeting room booking report Outlook VBA and Custom Forms 1
D How to Run a Report Based on Age of Inbox Items Outlook VBA and Custom Forms 0
Diane Poremsky Send a Task Status Report New Slipstick.com Articles 0
V Report stuck formatting page Using Outlook 1
J Outlook 2007 Rules & VBA: How to run a script on a report message (ReportItem) Using Outlook 14
D Report on mailboxes which have exceeded quota? Exchange Server Administration 1
D Report from forms Outlook VBA and Custom Forms 3
T email Access report pop up network error Outlook VBA and Custom Forms 1
K BCM 2010 report error BCM (Business Contact Manager) 6
R Using 'Company Name' in a BCM report!! BCM (Business Contact Manager) 1
F company field won't show in report BCM (Business Contact Manager) 5
F Open task from is own status report in Public Folders Outlook VBA and Custom Forms 3
T Is any body knows how to add #company name# to report? BCM (Business Contact Manager) 1
J Modifying a Business Contact Manager Report BCM (Business Contact Manager) 1
H Error in values when exporting report to Excel BCM (Business Contact Manager) 1
S Problem Checking the available stores in my Inbox (Outlook VBA) Outlook VBA and Custom Forms 0
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
F "This action is not available in the current mode" Using Outlook 0
Bri the Tech Guy Registry Tweak to make "Run a Script" Action Available Outlook VBA and Custom Forms 2
D Next Available Meeting with Userform Variables Outlook VBA and Custom Forms 1
Ascar_CT Rule behavior analysis - any tools available? Using Outlook 0
E for Mac: Assign Task not available!? Using Outlook 1
T How to create meeting recurrences that are not available in the appointment screen? Using Outlook 1
M Predefined Outlook Fields not available to add into a BCM record BCM (Business Contact Manager) 0
S Newly added user doesn't show up in GAL but available in OWA, Using Outlook 0
T Column Header Keyboard Shortcut Available? Using Outlook 5
J 45 This mail is not currently available (IMAP) Using Outlook 1
C My BCM Database is no longer available to be shared with the Database Tool BCM (Business Contact Manager) 3
B OWA Calendar Views not available Exchange Server Administration 2
M Windows desktop search not available Using Outlook 2
H Outlook 2010 Antispam Addin Not Available Using Outlook 1
A Are Public Folders Contacts available through activesync for Windows Phone 7, Iphone, etc? Exchange Server Administration 3
J ModefiedForm page issues 1)retrieving available size of Modifiedfo Outlook VBA and Custom Forms 3
M The server is not available. Contact your administrator if this co BCM (Business Contact Manager) 1
O using VSTO to get Available Mailboxes Outlook VBA and Custom Forms 11
C Make Field Available If A Crietria In The Other Field is Selected Outlook VBA and Custom Forms 1
R how to display Bcc if not available? Outlook VBA and Custom Forms 1
L Outlook 2019 MAC sync error after working for 4 hours Using Outlook 1
G Calendar View in Outlook Office 365 - Doesn't show enough hours, and the 30/60 min choice isn't the solution Using Outlook 4
Venkata Murugan Guna How to sum hours, minutes, or seconds in Outlook Using Outlook 51
GregS Outlook mail arrives in batches, sometimes hours late Using Outlook 1
Diane Poremsky How to Process Mail After Business Hours New Slipstick.com Articles 0
Diane Poremsky How to Always Process Mail After Business Hours New Slipstick.com Articles 0
C Need rule to alert when an email has not been replied to within 24 hours Using Outlook 1
M Outlook Is Disconnected In the Morning Or After Few Hours Exchange Server Administration 1

Similar threads

Top