Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Track info from one w/sheet onto another. | Excel Worksheet Functions | |||
Can I link Contact info into an Excel doc? | Excel Worksheet Functions | |||
Can I create a form to run off of info saved on Excel 97? | Charts and Charting in Excel | |||
paste info into merged cells | Setting up and Configuration of Excel | |||
trying to sort/farmat scanned info | Excel Discussion (Misc queries) |