Forum Discussion
If/then formula for date/time
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!
