ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tool/template to track available time on calendar (https://www.excelbanter.com/excel-discussion-misc-queries/87478-tool-template-track-available-time-calendar.html)

Rubygirl

Tool/template to track available time on calendar
 
What's the best tool to use (Excel?) to allow me to compare available times
of several people? I currently call people to inquire about their
availability for meetings. I would like to build a spreadsheet that will
sort through the info I gather and determine the best time to hold the
meeting. Giving me permissions to all their calendars would not be feasible.

Peo Sjoblom

Tool/template to track available time on calendar
 
You would be much better off using Outlook or Lotus notes for this, excel
has nothing built in so you would need to construct it yourself so to answer
your question Excel is not the best tool for this


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Rubygirl" wrote in message
...
What's the best tool to use (Excel?) to allow me to compare available
times
of several people? I currently call people to inquire about their
availability for meetings. I would like to build a spreadsheet that will
sort through the info I gather and determine the best time to hold the
meeting. Giving me permissions to all their calendars would not be
feasible.




Dave Peterson

Tool/template to track available time on calendar
 
If your department is balking at giving you permissions to view their outlook
calendar, there is an option where they can mark times as private.

Others won't see why they're not available, but will see that they are
unavailable.

(I think you need MS Exchange server, too, IIRC. But it's been a while.)



Rubygirl wrote:

What's the best tool to use (Excel?) to allow me to compare available times
of several people? I currently call people to inquire about their
availability for meetings. I would like to build a spreadsheet that will
sort through the info I gather and determine the best time to hold the
meeting. Giving me permissions to all their calendars would not be feasible.


--

Dave Peterson


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com