View Single Post
Old 09-21-2019, 09:59 AM   #1
FerrariEnzo
I answer every Emotion with an emoticon
 
FerrariEnzo's Avatar
 
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.

__________________
My Buy&Sell Feedback, Thanx
FerrariEnzo is offline   Reply With Quote