If/then formula for date/time

Copper Contributor

I am trying to write a formula to determine if a date/time combination is before or after 2:00 PM. The format of the data is like this,  "10/5/2021 15:03" but when I click into the cell it shows "10/5/2021 3:03:00 PM". Everything I have tried as not worked as expected.  Woudl really appreciate some input from anyone.  thanks in advance.

2 Replies

@collinsj75 Let's say the time/date stamp is in A1, use this:

=MOD(A1,1)>(14/24)

TRUE = after 2PM

False = before 2PM

Works perfectly! thank you!