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.
dscheikeyBronze ContributorJul 31, 2022Mikedgw1 B1 = IF(A1>VALUE("00:04:00"),0,1) In cell A1 you have the timecode. In B1 the If() function.
Mikedgw1Copper Contributor to dscheikeyJul 31, 2022Thank you.I was able to get it with this reply. I did have to remove the first two zeros though. Probably due to my cell only showing minutes and seconds.
Mikedgw1Copper Contributor to dscheikeyJul 31, 2022Thank you.I was able to get it with this reply. I did have to remove the first two zeros though. Probably due to my cell only showing minutes and seconds.
