Pretty simple time problem

Hey guys,

First time poster and an idiot at excel. I've done a bit of programming in python/java but that just seems to confuse me when it comes to the syntax of excel functions.

Right, what i'm planning to do is create a spreadsheet that compares the clock in time for an employee against their rostered clock in time and flags any that are out by greater than 7 minutes, either way. I've got this working fine (Refer to conditional formatting in colums O and P).

The bit im struggling with as as follows:

I want column Q to display the correct amount of hours worked ONLY if the automatic clock in time is within 7 minutes either side of the rostered clock in time.

By automatic clock in time i mean column E 'Roundstart' and by rostered clock in time i mean column M 'Start'.

As you can see in Q7, it works if the automatic clock in time and rostered clock in time are EXACTLY the same but i need the 7 minute leeway each way (early or late)..

Any tips would be greatly appreciated...

Thanks,

Drummerkid