Forum Discussion

Mikedgw1's avatar
Mikedgw1
Tin Contributor
Jul 31, 2022
Solved

Formula 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.

Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Jul 31, 2022

    Mikedgw1

     

     

    B1 = IF(A1>VALUE("00:04:00"),0,1)

     

     

     

    In cell A1 you have the timecode. In B1 the If() function.

3 Replies

  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Jul 31, 2022

    Mikedgw1

     

     

    B1 = IF(A1>VALUE("00:04:00"),0,1)

     

     

     

    In cell A1 you have the timecode. In B1 the If() function.

    • Mikedgw1's avatar
      Mikedgw1
      Tin Contributor
      Jul 31, 2022
      Thank 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.