Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 16 Apr 2024 15:52:36 +0000

How to Post a Message for Support

Post From: Spread Sheet Entry

[2013-09-05 15:21:26]
[Go To First Post]
Sawtooth - Posts: 3973
Try using the TIMEVALUE function, and cell J41.

Maybe like this:

=AND($J$41-INT($J$41)>TIMEVALUE("09:29:59"),$J$41-INT($J$41)<TIMEVALUE("09:30:02"))