Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 02 May 2024 17:35:45 +0000
Post From: spreadsheet question
| [2014-08-05 19:33:18] |
| vegasfoster - Posts: 444 |
|
Try this, In I90, "FLATTEN HOUR=" In J91, "FLATTEN MINUTE=" In J90, enter hour you want to exit, from 0 to 23 In J90, enter minute you want to exit, from 0 to 59 In J29, =IF(TIME(DAY(A3),HOUR(A3), MINUTE(A3)) >= TIME(DAY(A3),HOUR(J90), MINUTE(J91)), TRUE, FALSE) Or could simply replace HOUR(J90) and MINUTE(J91) with desired figures, e.g. for 1:00 p.m. would use, In J29, =IF(TIME(DAY(A3),HOUR(A3), MINUTE(A3)) >= TIME(DAY(A3), 13, 0)), TRUE, FALSE) |