Support Board

Date/Time: Wed, 27 Nov 2024 08:35:08 +0000

Post From: spreadsheet question

[2014-08-05 19:33:18] Link To Thread - Link To Post [Go To First Post]
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)