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.

https://i.imgur.com/vvpZArd.jpg

https://www.dropbox.com/s/yjh6fie80m...ook1.xlsx?dl=1

Would this work for you?

Awesome, that works

Hi,

I have another dilemma, I need another formula help.

https://i.imgur.com/lgfLEqk.jpghttps://i.imgur.com/RTKBNR2.jpg

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?

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.

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.