Mikedgw1Copper ContributorJul 31, 2022SolvedFormula help I need a formula that returns a 1 or 0 based on if a cell is <=4:00. That is 4 minutes. 0 if above and 1 if lower. Any help would be appretiated. dscheikeyJul 31, 2022Mikedgw1 B1 = IF(A1>VALUE("00:04:00"),0,1) In cell A1 you have the timecode. In B1 the If() function.
dscheikeyJul 31, 2022Mikedgw1 B1 = IF(A1>VALUE("00:04:00"),0,1) In cell A1 you have the timecode. In B1 the If() function.
dscheikeyJul 31, 2022Mikedgw1 B1 = IF(A1>VALUE("00:04:00"),0,1) In cell A1 you have the timecode. In B1 the If() function.
HansVogelaarMVPJul 31, 2022Mikedgw1 Or =--(A1<=TIME(0,4,0)) or =--(A1<=TIME(4,0,0)) where A1 is the cell with a time.
