LinkBack URL
About LinkBacks
Hi everyone I have a problem to find out the Overtime worked > 7.5 hours or if < then 0 in column G
much appreciated
Karl
Hi everyone I have a problem to find out the Overtime worked > 7.5 hours or if < then 0 in column G
much appreciated
Karl
Try this:
=IFERROR(IF(COUNT(TimeSheet[@[Time In]:[Time Out]])=4,(TimeSheet[@[Time Out]]-TimeSheet[@[Time In]])-(TimeSheet[@[Lunch End]]-TimeSheet[@[Lunch Start]]),TimeSheet[@[Time Out]]-TimeSheet[@[Time In]]),"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
It does not work see Attachment
So then explain how you would calculate the results manually. "It does not work" is of no use to me - it doesn’t help.
Use
in G10
=MAX(0,[@[Hours Worked]]-7.5)
Hi Guys it worked just fine but in G10 it needs to be a maximum of 2 hours
Try
=MIN(2,MAX(0,[@[Hours Worked]]-7.5))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks