Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2011, 10:56 PM
Coldplay Coldplay is offline excel Help Windows 7 32bit excel Help Office 2010 32bit
Novice
excel Help
 
Join Date: Nov 2011
Posts: 2
Coldplay is on a distinguished road
Default excel Help

I am doing a timetable off people in a place. I need too do this timetable and a diagram with how many people that are at the place at the same time. i can do the table but the diagram i canīt....

The table can look like this....

Berit: Monday 08:00-17:00 Tuesday 7:00-15:30 Wednesday 9:00-16:00 Thursday 7:20-17:20 Friday 8:00-14:00



Sven: Monday 08:45-15:30 Tuesday 7:00-16:30 Wednesday 7:00-16:00 Thursday 8:20-17:20 Friday 8:00-16:00

Tor: Monday 7:00-12:15 Tuesday 7:00-14:30 Wednesday 8:30-16:00 Thursday 7:20-15:20 Friday 7:00-16:10
Reply With Quote
  #2  
Old 11-25-2011, 02:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline excel Help Windows XP excel Help Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi

maybe post a sample sheet with what you have and what you need
Reply With Quote
  #3  
Old 11-25-2011, 02:45 AM
Coldplay Coldplay is offline excel Help Windows 7 32bit excel Help Office 2010 32bit
Novice
excel Help
 
Join Date: Nov 2011
Posts: 2
Coldplay is on a distinguished road
Default

This is just a test file but i can look like this but i have 42 people too keep track off. i want too know how many i have in the premises. The time i want too keep track off is 7 a clock, 8 a clock 9 a clock in the morning how many i have att lunch 11:30 and how many at the afternoon att 15:00, 16:00 and after 17:00
Attached Files
File Type: xlsx TEST.xlsx (12.9 KB, 11 views)
Reply With Quote
  #4  
Old 11-26-2011, 01:16 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline excel Help Windows XP excel Help Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Does this help ? ( see attached)
Start and end time were placed in different columns
Attached Files
File Type: xlsx TEST(4).xlsx (13.0 KB, 8 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel Help VBA code from Excel 2007 in Excel 2010 csam63 Excel Programming 1 10-07-2011 10:46 AM
excel Help Excel Hyperlinks crash Excel programme martinlest Excel 8 01-26-2011 04:23 AM
excel Help Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft