CODEWITHSUNDEEP
excel
Captionless
Captionless

Reputation: 63

Excel if current time is later than given time then equal to yes

Needing help with this formula. What I hope to achieved is that when current time past the shift time then yes, if not then no. What formula should I use?

enter image description here

Upvotes: 1

Views: 1670

Answers (2)

Ashgabat
Ashgabat

Reputation: 81

Try this way:

  1. Use this formula in "C2": =NOW()-TODAY()
  2. Use this formula in "D5": =IF($C$2>C5,"Yes","No")
  3. Copy the formula down.

I think it will work.

Upvotes: 2

Ferdinando
Ferdinando

Reputation: 964

You can try also this one:

enter image description here

In Column E you write =IF($C$2-D4>0,"Yes","NO")

Next, copy the formula to other cells in column E.

Upvotes: 1

Related Questions