Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge > Media Center

Reply
 
Thread Tools Display Modes
Old 09-15-2011, 08:26 AM  
crispystl420 crispystl420 is offline
Veteran
 
crispystl420's Avatar
 
Join Date: Jun 2004
Casino cash: $31250
Excel Gurus

Does anyone know what kind of formula I could use to track total weekly hours in this spreadsheet. I could do it using military time but that probably wouldn't work for some of the staff (they have enough trouble with standard time). I have tried google and I can't get anything to work.

Thanks in advance

Oops forgot the attachment
Attached Files
File Type: xls new SCHEDULE.xls (845.5 KB, 60 views)

Last edited by crispystl420; 09-15-2011 at 08:39 AM..
Posts: 3,334
crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.
  Reply With Quote
Old 09-15-2011, 08:32 AM   #2
Fish Fish is offline
Missing Dick Curl
 
Fish's Avatar
 

Join Date: Sep 2005
Casino cash: $2113385
Looks like you need to take the inverse square of A-B, and multiply that by .12, then subtract the average of C-B/4.

That should do it.
__________________
Posts: 24,580
Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.
  Reply With Quote
Old 09-15-2011, 08:38 AM   #3
Dayze Dayze is online now
Pie
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $1223156
what exactly do you need to do?
Posts: 22,574
Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.
  Reply With Quote
Old 09-15-2011, 08:40 AM   #4
crispystl420 crispystl420 is offline
Veteran
 
crispystl420's Avatar
 

Join Date: Jun 2004
Casino cash: $31250
Quote:
Originally Posted by Dayze View Post
what exactly do you need to do?
I need a formula that will calculate an employees total weekly hours automatically.
Posts: 3,334
crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.
  Reply With Quote
Old 09-15-2011, 08:41 AM
Dayze
This message has been deleted by Dayze. Reason: not needed
Old 09-15-2011, 09:15 AM   #5
Dayze Dayze is online now
Pie
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $1223156
assuming you're working from the 'new schedule' tab...

the forumla you need is
"HOUR(D3-C3)" etc

you can copy and paste this down for all personnel.
I just did a quick example (attached); added colums for each day to capture that days' totals; then hid the columns. Added a colum that totaled up each employees hours etc.

you can see the formula if you unhide the colums etc.
Attached Files
File Type: xls new%20SCHEDULE(1) - V1.xls (982.0 KB, 59 views)
Posts: 22,574
Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.
  Reply With Quote
Old 09-15-2011, 11:14 AM   #6
crispystl420 crispystl420 is offline
Veteran
 
crispystl420's Avatar
 

Join Date: Jun 2004
Casino cash: $31250
Quote:
Originally Posted by Dayze View Post
assuming you're working from the 'new schedule' tab...

the forumla you need is
"HOUR(D3-C3)" etc

you can copy and paste this down for all personnel.
I just did a quick example (attached); added colums for each day to capture that days' totals; then hid the columns. Added a colum that totaled up each employees hours etc.

you can see the formula if you unhide the colums etc.
Thanks that works except it doesn't track half hours. Is there any way to do that?
Posts: 3,334
crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.
  Reply With Quote
Old 09-15-2011, 11:31 AM   #7
Dragonocho Dragonocho is offline
Starter
 
Dragonocho's Avatar
 
Helicopter2 Champion
Join Date: Dec 2010
Location: Lansing
Casino cash: $16859
Quote:
Originally Posted by crispystl420 View Post
Thanks that works except it doesn't track half hours. Is there any way to do that?

Right click all the blocks that are tracking hours. Select format cells. Select numbers as the format with the decimals set to 1.
Posts: 481
Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.Dragonocho must have mowed badgirl's lawn.
  Reply With Quote
Old 09-15-2011, 04:33 PM   #8
Detoxing Detoxing is offline
Dyslexic Speed Reader
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $449751436
That looks terrible dude. Do you still need help? I don't have a sheet for tracking ALL of the employee hours anymore, but I do have a bitchin' time card for individuals. You simply enter the employee's clock in/out times and it calculates the total hours for you. You could probably steal the idea and make it work for you. Let me know.
Posts: 17,735
Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.
  Reply With Quote
Old 09-15-2011, 04:46 PM   #9
crispystl420 crispystl420 is offline
Veteran
 
crispystl420's Avatar
 

Join Date: Jun 2004
Casino cash: $31250
Quote:
Originally Posted by Detoxing View Post
That looks terrible dude. Do you still need help? I don't have a sheet for tracking ALL of the employee hours anymore, but I do have a bitchin' time card for individuals. You simply enter the employee's clock in/out times and it calculates the total hours for you. You could probably steal the idea and make it work for you. Let me know.
Yeah man that would be freaking awesome. All I need is individual hours any ways. Thanks to everyone for your help.
Posts: 3,334
crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.
  Reply With Quote
Old 09-16-2011, 11:44 AM   #10
Detoxing Detoxing is offline
Dyslexic Speed Reader
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $449751436
So...how do I post a spread sheet on here?
Posts: 17,735
Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.Detoxing has an IQ even higher than Frankie's.
  Reply With Quote
Old 09-16-2011, 11:47 AM   #11
Dayze Dayze is online now
Pie
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $1223156
the addtional options section of the Reply window.
I found that out yesterday lol.....only took me 8 years.
Posts: 22,574
Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.
  Reply With Quote
Old 09-16-2011, 06:56 PM   #12
crispystl420 crispystl420 is offline
Veteran
 
crispystl420's Avatar
 

Join Date: Jun 2004
Casino cash: $31250
Quote:
Originally Posted by Detoxing View Post
So...how do I post a spread sheet on here?
Do you want my e-mail address?
Posts: 3,334
crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.
  Reply With Quote
Old 09-16-2011, 06:57 PM   #13
crispystl420 crispystl420 is offline
Veteran
 
crispystl420's Avatar
 

Join Date: Jun 2004
Casino cash: $31250
Quote:
Originally Posted by Dayze View Post
the addtional options section of the Reply window.
I found that out yesterday lol.....only took me 8 years.
Lol I was trying to figure that out after I forgot to attach the file to my original post.
Posts: 3,334
crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.crispystl420 would the whole thing.
  Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -6. The time now is 03:50 AM.


Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.