Scheduling Question

Hi,

I am very new to Excel, but am trying to do a very simple task. I am making a spreadsheet that we (our work group) can input our schedule into and then it can be imported into Outlook so it will appear on our calendars. I have had success uploading the schedule and populating our calendars, but I wanted to make the inputting of the data easier.

Here's what I am trying to figure out how to do:

In Column B, there are about 25 text fields that we could enter for where we might be.

I want to format columns D and F such that if a certain text field is entered in column B, a start time will be entered in D and an end time in F.

For example, if B says Chest Reading Room, I want D to say 7 am and F to say 5 pm. If B says Emergency Room, I want D to say 6 am and F to say 12 pm, etc., for each of the job assignments we could have.

Is there a way to do this?

Thanks!

First, for your 25 different jobs, I would use data validation and a combo box to ensure that you don't end up with typos.

Look here for creating this: http://office.microsoft.com/en-us/ex...001087228.aspx

In Excel 2003, you are limited to nesting 7 if statements which could be used to input the times, but with 25 different options, you will probably have to use VBA and Select Case statements.

http://www.techonthenet.com/excel/fo.../if_nested.php

http://www.techonthenet.com/excel/macros/if_custom.php

Edit: Just had a thought, you could build a table for each of the 25 different tasks and the start time and the end time. Then use the vlookup to populate your calendar.

http://www.techonthenet.com/excel/formulas/vlookup.php