Support Board
Date/Time: Sat, 28 Dec 2024 07:37:56 +0000
Post From: spreadsheet study and time
| [2015-12-23 22:05:17] |
| Sawtooth - Posts: 4143 |
|
Oops. Use this instead: =AND($J$41-INT($J$41)>=TIMEVALUE("08:00:00"),$J$41-INT($J$41)<=TIMEVALUE("08:10:00"),CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4,ID3.SG1@3:ID3.SG1@4)) J41 includes the date and time, and the TIMEVALUE function is only the time, so $J$41-INT($J$41) is needed to remove the date and leave only the time. |