Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GrandMasterRyGuy
 
Posts: n/a
Default Don't know how to organize info I have.

I am trying to organize info in regards to when the most people are best able
to gather at the same time to complete a certain task. I had everybody give
me the times they are best able to be there to complete this task (based on
24 hours) for each day of the week (Sunday through Saturday).

What I want to do is create some type of table/chart where I can take all
this info and show each person and the times they are avaiable. From there, I
want it to be able to compile these times together and show me which hours
and which people are able to come together for this task each day of the week.
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

how to approach this would, IMHO, depend on how much info (ie number of
people and how many times they have each given you and in what time of
blocks (ie 5 min blocks or 1 hour blocks).

If there is not too large an amount of data (ie how much do you like typing)
i would set it up so that the people's names were across row 1
and days and times down column A - to ensure that Excel thinks it is a date
& time i would type (in A2 or A3)

control & semi-colon (;)
press the spacebar
control & colon (:)

this will give you the current date & time in a format that excel is happy
with (you can format it to anything you like once you've generated the
times) .. now edit it to 1am of the first date that you want to look at and
fill this down to the next line - edit this line to the same day, but the
next time period (e.g. 1hr later or whatever) ... now select both dates and
drag down on the fill handle (bottom right corner +) until you get to the
last date & time you're interested in.

Then just simply go through the list either each person's availability - i
would use a simple "y" for available.

Once you've got all the "y" entries, select your list (exclude dates &
names) and choose format / conditional formatting
choose cell value is equal to y
and click on the format button - set a font colour & pattern to the same
colour and click OK twice - now you have a visual chart or each person's
availability.

to determine the best time to get everyone together - add another column in
at the end - called "# Available" (or whatever) - say this is F1,
in F2 type the following formula
=COUNTIF(B2:G2,"y")
and fill down
this will tell you the number of people who can make it in that time period,
now select column F
choose format / conditional formatting
choose
formula is
type
=MAX($F$2:$F$1000)
click the format button and set a bright format for the highest number of
people who can get together at the same time.

Hope this helps
-
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"GrandMasterRyGuy" wrote in
message ...
I am trying to organize info in regards to when the most people are best
able
to gather at the same time to complete a certain task. I had everybody
give
me the times they are best able to be there to complete this task (based
on
24 hours) for each day of the week (Sunday through Saturday).

What I want to do is create some type of table/chart where I can take all
this info and show each person and the times they are avaiable. From
there, I
want it to be able to compile these times together and show me which hours
and which people are able to come together for this task each day of the
week.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Track info from one w/sheet onto another. Ilga Excel Worksheet Functions 0 April 29th 05 04:44 PM
Can I link Contact info into an Excel doc? brownbag_dab Excel Worksheet Functions 0 April 28th 05 09:55 PM
Can I create a form to run off of info saved on Excel 97? Pajama sam Charts and Charting in Excel 1 March 19th 05 01:34 PM
paste info into merged cells Marc Setting up and Configuration of Excel 0 December 6th 04 10:09 PM
trying to sort/farmat scanned info eternallygrateful Excel Discussion (Misc queries) 2 November 30th 04 08:17 PM


All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"