Multiple IF statements, Cant work out formula

[dazzamac85]

Help with IF Statement/Count IF

So I have 2 sheets

Sheet1 = Column A has a list of dates (14/05/2018)
= Column B has a list of names (John Smith)
= Column C has a Start Time (14/05/2018 10:00)
= Column D has a Finish Time (14/05/2018 22:00)
= Column E is the difference between D+C (12:00:00) - (h)hh:mm

Sheet2 = Column A has a list of dates (14/05/2018)
= Column B has a list of names (John Smith)
= Column C has a working shift length (08:00:00) - (h)h:mm


I want to in Sheet1 Column E calculate the difference between D+C but condense the result to not be any longer than Column C in Sheet2.
As the data will have long lists of names and different dates. I need to use the Date and Name in both Sheets to match.

please help

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem - tell us what you are trying to do. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.