How to return if statement if greaterthan hours and minutes

[Davis91]

Good evening all,

Can anyone help me with the returning an if statement for Hours and minutes. I currently have the following;

Start time: 07:00AM ----- Format HH:MM AM/PM
Finish time: 5:00PM ----- Format HH:MM AM/PM

Total Hours: 10:00 ----- Format HH:MM

IF statement: =IF(HOUR($H7)>=10,"Yes","No")

So it will return yes if total is 10 Hours or more

However I need it to return No if the total is 10 hours, but Yes if the total is 10Hours 1 minute

Thank you in advance

 

[arthurbr]

Perhaps =IF(HOUR($H7)<=10,"No","Yes")

 

[Sajukai]

=IF($H7>=Time(10,1,0),TRUE,FALSE)

 

[Davis91]

=IF($H7>=Time(10,1,0),TRUE,FALSE)

Perfect!! Thank you very much Sajukai

Thank you Arthurbr also

 

[arthurbr]

You're welcome