Hi Guys and Ladies!

I was wondering is there such template??

Basically what I want to do is:

I have a column with activities, call it column A. Beside this I have a column of time required for each activity to be accomplished, let’s call this column B. I then have another column with names of the places where the activities are located let’s call this column C.

I need a time table template where it will go through the times and assort the places with their subsequent times in the following manner- shortest times go in to Monday to Friday and longer times go to Saturday to Sunday. It needs to determine if it’s short or long period automatically.

Here is an example:

Data:

Swimming 30m Moscow
Diving 40m Moscow
Shopping 2h London
Biking 50m Berlin
Fishing 2d Moscow
Walking 30m Dublin
Biking 1h20m Dublin
Fishing 4d Berlin
Walking 2h15m London
Diving 20min London
Shopping 50min Berlin
Biking 30min Dublin

Output:
Monday Dublin (after adding the time it evalute 2 working days for this)
Tuesday Dublin
Wednesday London
Thursday London
Friday Moscow
Saturday Moscow
Sunday Moscow (takes the most time so it aasings it to a weekend)

etc.

(the cities were used only as a reference just imagine you usual 15m-2h drive village away is called one of the above)

Any ideas on how I can achieve that in excel or is there other software which does that??

Any help will be greatly appreciated!

P.S. I use excel 2003