If time in column is greater than, then 1 else 0

[lgeraeds]

I have a Time data type column called "Aantal uren" with time values in it formatted like 04:48:00. I want to make a second column that does an if statement which checks if the value is greater then 08:00:00. 

I have tried doing it by this:

Column =

IF(([Aantal uren])>TIME(08,00,00),1,0)

But that gives me a strange result, for example, there is a value 04:34:47 in my column and the above formula gives 1 for result. The same happens with value 02:59:14

I have also tried it with IF(([Aantal uren])>8,1,0) but that does the same thing. 

Thank you for your help.

[lgeraeds]

That was the problem, thanks! 

[VahidDM · Accepted solution]

Hi @lgeraeds 

Have you checked the AM and PM of those two times?

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!