Oct 06 2021 07:59 AM
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.
Oct 06 2021 08:12 AM
@collinsj75 Let's say the time/date stamp is in A1, use this:
=MOD(A1,1)>(14/24)
TRUE = after 2PM
False = before 2PM