Best method to compare time column to timenow()

[Patrick_Paul]

Hello!  I'm trying to set up a bot that runs at the top of every hour and looks to send out an email message if the column "Virtual Time" which is of type Time (and is expected to contain top-of-the-hour times such as 8:00:00 AM) and timenow() are equal, in other words, it's happening "now".  I've found this is a bit too precise, because the milliseconds of timenow() and the value of the time column will never be exactly the same, even if the bot fires off right at the top of the hour. 

Looking for suggestions on a better way to accomplish this.  Possibly checking for totalhours() between the time column and timenow()?  Perhaps like:  totalhours([virtual time]-timenow())<1...? 

Thanks in advance for any help!

[lynchk21]

Would comparing the hour value and the minute value work?

AND(HOUR(TIME(NOW()) - "00:00:00")=HOUR(TIME([virtual time]) - "00:00:00"),MINUTE(TIME(NOW()) - "00:00:00")=MINUTE(TIME([virtual time]) - "00:00:00"))

[Marc_Dillon]

Can you change your Time column to be DateTime? Then you could simply compare NOW() > [datetime].