Support Board
Date/Time: Wed, 17 Dec 2025 04:08:41 +0000
Post From: Spread Sheet Entry
| [2013-09-05 15:21:26] |
| Sawtooth - Posts: 4299 |
|
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")) |
