macro t compare column and return OK or CHECK

[coolhit]

Hi

I have 2 sheet
1-"Check Employee Hours"
2-"Check Hours"

Below is what Check Employee Hours looks like

Below is what Check Hours looks like

I want to the user to press ebutton i.e Sunday and macro does the comprsion.

Process

I would like macro to look at sheet "Check Hours" column "E" (cell E4) and compare it against the sheet "Check Employee Hours" column "E" (cell E7). If the hours matches i would like to say OK on sheet "Check Hours" cell E4, if it doesn't match then say CHECK.

Please can someone help as i have been trying for over a week now and not getting anywhere.

Any assistant would be appricated.

Regards

 

[Mavericks334]

If your entering your time with decimal point you need to convert it so it will represent the accurate time. If you have entered your time in column d=

The in column E convert it to = D2/(24*60) will give = 16.50/(24*60) = 16:30