Calendar statistics

Status
Not open for further replies.

AAscensi

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
hello,

I want to have monthly stats from my Outlook 2010 Calendar :

For each month, the total duration by categories

(I can do it with a Sharepoitn Calendar connect to an Access base but with an Outlook calendar the start, end and duration fields aren't available from Access).

Is it possible to create a view by categories with total for the duratio field ?

Thank's for your help.

Arnaud
 

Forum Admin

Senior Member
Is it possible to create a view by categories with total for the duratio field ?

No, outlook doesn't show totals but you can copy and paste into Excel and do the calculations. A tutorial on using outlook data in Excel (and other programs) is here: http://www.slipstick.com/tutorial/no-export-way-to-use-outlook-data/

This method will work to paste data into Access too, using a table view. Make sure the fields in Outlook are in the same order and any blank Access fields are at the end of the row. Select the rows in outlook, select the last row (the 'new row' row) in the access table and paste.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Duplicate calendar entries in Outlook 365 Using Outlook 2
G Stop Outlook 365 adding meetings to calendar Using Outlook 0
Christopher M Outlook 365 HELP! Calendar Craziness! Using Outlook 7
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
Commodore Slow calendar Using Outlook 0
C How to import Outlook calendar? Using Outlook 1
G Add contacts birthday to calendar Using Outlook 4
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
V iCloud calendar problems, Outlook shuts down immediately Using Outlook 2
KeithJB iCloud calendar sync only works one way! Using Outlook 3
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
O Unable to make changes to an existing Calendar entry Using Outlook 11
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Using Outlook 0
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Exchange Server Administration 0
T Outlook 2010 Cannot edit Calendar entries in OL 2010. Using Outlook 1
M On behalf of not showing on calendar for boss Using Outlook 1
C Outlook 2016 Unable to delete Gmail IMAP calendar Using Outlook 3
A force outlook to default to MY calendar Using Outlook 3
O Carriage Return - Line Feeds - exporting Calendar events Using Outlook 0
K How to share multiple calendar items Using Outlook 1
P Calendar Day View only shows 1 all day event Using Outlook 0
Hobbes Outlook 365 Calendar spreads into second calendar Using Outlook 3
J Macro to Insert a Calendar Outlook VBA and Custom Forms 8
C Tracking Calendar Changes? Using Outlook 1
O Batch update calendar Using Outlook 3
P Outlook calendar and contacts sync problem-outlook disconnects Using Outlook.com accounts in Outlook 2
HarvMan Toggle between calendar and email in Outlook 365 Using Outlook 12
e_a_g_l_e_p_i Is it possible to transfer things from one calendar to another Using Outlook 2
M Outlook calendar is missing Using Outlook 2
A Any way to make Outlook Calendar invitations look right to Gmail/Google Calendar users? Using Outlook 3
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1
I Outlook is stuck at "Updating Calendar" Using Outlook 1
AmonRa Outlook 365 calendar - too much white space Using Outlook 0
M Cannot read the calendar Using Outlook 9
Horsepower What is best calendar practice for iMac Using Outlook 3
M Calendar greyed out Using Outlook 0
M Unable to share 2019 calendar Using Outlook 0
Fozzie Bear Accepted Zoom Invites deleting without going into Default Calendar - Office 2016 Mac Using Outlook 3
P Outlook 2013 Calendar Archiving Using Outlook 0
Fozzie Bear Sharing Birthday Calendar Using Outlook.com accounts in Outlook 3
M Calendar daily Appointments and printing Using Outlook 0
I Google Calendar <calendar-notification@google.com> appearing as a duplicate entry Using Outlook 2
L Sharing Calendar for Only Scheduling Using Outlook 2
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 3
E Work uses live accounts for emails for all employees. Can we use the outlook calendar to give the employees an universal work schedule calendar? Using Outlook 1
J O365 - Adding Shared Google Calendar ICS link issue in O365 Using Outlook 0
B Outlook Calendar not coming down from cloud Using Outlook 2
J Time Zone Issues - Outlook Calendar and Webcal Feed Using Outlook 8
N Backing Up Exchange Calendar Using Outlook 13

Similar threads

Top