Computer Tech, Gaming & Electronics THIS SPACE OPEN FOR ADVERTISEMENT. YOU SHOULD BE ADVERTISING HERE!
Silicon Valley.
Tips & tricks, tech support, home theatre, online gaming, reviews, latest news... |
 | 
09-21-2019, 09:59 AM
|
#1 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
Failed 1,234 Times in 307 Posts
| Excel formula help
Just a quick question on how to get a predicted Clock Out time for the week with 60.5 hours MAX.
So basically, 60.5 hours - Total Time = Recommended Clock out time, if they have a clock in time (column F).
If the remaining hours is greater then 12 hours, have it display a text (Safe)
So lets say someone has worked 55 hours and has clocked in today at 730am, he needs to clock out by 1pm.  | 
|  | |
09-21-2019, 10:52 AM
|
#2 | | I STILL don't get it
Join Date: Aug 2015 Location: Main & Hastings
Posts: 465
Thanked 497 Times in 161 Posts
Failed 0 Times in 0 Posts
|
Last edited by ssjGoku69; 09-21-2019 at 10:57 AM.
| |
| | |
09-21-2019, 02:47 PM
|
#3 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
Failed 1,234 Times in 307 Posts
|
Awesome, that works
| |
| | |
10-11-2019, 01:45 PM
|
#4 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
Failed 1,234 Times in 307 Posts
|
Hi,
I have another dilemma, I need another formula help.  
What I want is, if I enter a date F2, all the points for Hockey, Baseball and Football will fill in. The Data tab is auto retrieving from a website, so the data will never be the same, there could be more or less, so adding a total to it wouldnt be feasible?
| |
| | |
10-11-2019, 09:09 PM
|
#5 | | To me, there is the Internet and there is RS
Join Date: Apr 2007 Location: Okanagan
Posts: 17,133
Thanked 9,904 Times in 4,313 Posts
Failed 433 Times in 231 Posts
|
If I'm understanding what you want correctly, then I believe it's doable, I'm just not 100% sure what the formula would be.
__________________ 1991 Toyota Celica GTFour RC // 2007 Toyota Rav4 V6 // 2000 Jeep Grand Cherokee
1992 Toyota Celica GT-S ["sold"] \\ 2007 Jeep Grand Cherokee CRD [sold] \\ 2000 Jeep Cherokee [sold] \\ 1997 Honda Prelude [sold] \\ 1992 Jeep YJ [sold/crashed] \\ 1987 Mazda RX-7 [sold] \\ 1987 Toyota Celica GT-S [crushed] Quote:
Originally Posted by maksimizer  half those dudes are hotter than ,my GF. | Quote:
Originally Posted by RevYouUp reading this thread is like waiting for goku to charge up a spirit bomb in dragon ball z | Quote:
Originally Posted by Good_KarMa OH thank god. I thought u had sex with my wife. :cry: | | |
| | |
10-12-2019, 01:45 AM
|
#6 | | I STILL don't get it
Join Date: May 2010 Location: Port Moody, BC
Posts: 493
Thanked 133 Times in 64 Posts
Failed 7 Times in 3 Posts
|
See if this works: https://drive.google.com/open?id=1c8...06kP-1T5AsN0IR
Catch is dates have to be on row 1, sport has to be on column b, and the order of the types of sports have to be in the same order on both sheets. This might actually be a lot easier with a pivot table
| |
| | |
10-12-2019, 06:13 AM
|
#7 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
Failed 1,234 Times in 307 Posts
| Quote:
Originally Posted by LuHua See if this works: https://drive.google.com/open?id=1c8...06kP-1T5AsN0IR
Catch is dates have to be on row 1, sport has to be on column b, and the order of the types of sports have to be in the same order on both sheets. This might actually be a lot easier with a pivot table | Thanks for the help, this looks like it would work.
| |
| | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | |
All times are GMT -8. The time now is 06:14 AM.
|
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
The banners on the left side and below do not show for registered users!
