Microsoft Outlook 2003 - Reports?
05 April 2005, 10:04 AM
#1
Scooby Regular
Thread Starter
Join Date: Jul 2002
Location: The land of Daisies and Bubbles!
Posts: 5,560
Likes: 0
Received 0 Likes
on
0 Posts
Microsoft Outlook 2003 - Reports?
Not my usual teritory I know but I have a question. Within Outlook 2003 you have the option to use coloured labels on the calendar - I use these loads to separate out travel time and work on different projects.
My question is - rather than tot these up manually at the end of each month, is there a report facility available aneywhere that can just tell me how much of each label there is for a given time period?
OR - is there an easy way to convert the file to something that can do that?
Thanks!
My question is - rather than tot these up manually at the end of each month, is there a report facility available aneywhere that can just tell me how much of each label there is for a given time period?
OR - is there an easy way to convert the file to something that can do that?
Thanks!
05 April 2005, 10:51 AM
#2
Scooby Regular
You can export the Calendar (Excel or CSV format), but I don't believe it exports the "Label" field.
Don't think there is anything built into Outlook to allow that sort of reporting and haven't seen anything off-the-shelf to extract it from Outlook.
Should be easy to create something in VB or .Net to create a report. Not my field of work though.
Stefan
Don't think there is anything built into Outlook to allow that sort of reporting and haven't seen anything off-the-shelf to extract it from Outlook.
Should be easy to create something in VB or .Net to create a report. Not my field of work though.
Stefan
05 April 2005, 12:12 PM
#3
Scooby Regular
Thread Starter
Join Date: Jul 2002
Location: The land of Daisies and Bubbles!
Posts: 5,560
Likes: 0
Received 0 Likes
on
0 Posts
Cheers Ozzy! 
You're right - it doesn't export the labels field - but when I saw what it could do I just changed the details for each event so I could organise it better!
Just having a minor battle with Excel when it comes to doing sums in time formats - anything that adds up to >24 confused it......
You're right - it doesn't export the labels field - but when I saw what it could do I just changed the details for each event so I could organise it better!
Just having a minor battle with Excel when it comes to doing sums in time formats - anything that adds up to >24 confused it......
05 April 2005, 01:52 PM
#4
Scooby Regular
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes
on
0 Posts
DBW:
Use the Sum function to add the dates but format the cell as a number; something like this:
Sum(A1:A5)*24 (deals with totals greater than 24)
This'll give you a decimal so use something like this:
=INT(SUM(A1:A5)*24) +((SUM(A1:A5)*24)-INT(SUM(A1:A5)*24))*60/100
The cell is still in number format but gives the correct minute value.
HTH
Mark
Use the Sum function to add the dates but format the cell as a number; something like this:
Sum(A1:A5)*24 (deals with totals greater than 24)
This'll give you a decimal so use something like this:
=INT(SUM(A1:A5)*24) +((SUM(A1:A5)*24)-INT(SUM(A1:A5)*24))*60/100
The cell is still in number format but gives the correct minute value.
HTH
Mark
Thread
Thread Starter
Forum
Replies
Last Post