Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Ed & Dave 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: $5025
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, 66 views)

Last edited by crispystl420; 09-15-2011 at 08:39 AM..
Posts: 3,337
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 online now
Missing Dick Curl
 
Fish's Avatar
 

Join Date: Sep 2005
Casino cash: $6959
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: 25,809
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 offline
Resident Glue Sniffer
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $8522
what exactly do you need to do?
Posts: 25,938
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: $5025
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,337
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 offline
Resident Glue Sniffer
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $8522
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, 64 views)
Posts: 25,938
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: $5025
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,337
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
 

Join Date: Dec 2010
Location: Lansing
Casino cash: $9877
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: 604
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
 
Detoxing's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $7241
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.
__________________
Don't half ass two things. Whole ass one thing.
Posts: 19,292
Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.
  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: $5025
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,337
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
 
Detoxing's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $7241
So...how do I post a spread sheet on here?
__________________
Don't half ass two things. Whole ass one thing.
Posts: 19,292
Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.Detoxing has enough rep power to blowy ou to bits.
  Reply With Quote
Old 09-16-2011, 11:47 AM   #11
Dayze Dayze is offline
Resident Glue Sniffer
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $8522
the addtional options section of the Reply window.
I found that out yesterday lol.....only took me 8 years.
Posts: 25,938
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: $5025
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,337
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: $5025
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,337
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 07:09 PM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.