 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Calendaring / October 2007Can I sum up all of my scheduled time in a view in Outlook 2007?
Hi all. I need to sum up all of my scheduled time as a total in hours preferably as a view. I've been toying around with views and filters but I couldn't find any easy way of doing this. There is no need to group it in any particular way but I would love to be able to see it per day, week and month (with a filter or otherwise). Can I do this directly in Outlook or do I need to extract the data to another tool? TIA. You could use the Duration field. I'd say it would be easier to work with the data if you export to Excel. That is, assuming it exports that field. Another option is to customize the view to include the Duration field and add and omit any other fields you want or don't want. You can then copy using Shift (or Ctrl) + click and Ctrl + C and Paste into Excel. Get the view the way you want it first.  SignatureBill R > Hi all. > [quoted text clipped - 13 lines] > > TIA. Just to add to my reply - you are doing this in a table-based view. SignatureBill R > Hi all. > [quoted text clipped - 13 lines] > > TIA. Thanks Bill - I'll give this a shot. -- Martin > Just to add to my reply - you are doing this in a table-based view. > [quoted text clipped - 15 lines] > > > > TIA. Hi again Bill. I can't find a good way to export data to Excel from Outlook but if I cut and paste the duration fields into Excel I can nudge it around a bit and get it the way I want it with relative ease. My biggest problem right now is that the Duration field always contains 'h' or 'hours' or some such which I need to strip in Excel. I'll see if I can work around this somehow... Thanks again. -- Martin > Just to add to my reply - you are doing this in a table-based view. > [quoted text clipped - 15 lines] > > > > TIA. The Excel guys should know best how to deal with the data once you get it there. Try in an Excel forum if you get stuck. SignatureBill R > Hi again Bill. > [quoted text clipped - 34 lines] >> > >> > TIA. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.