I have looking for a formula to identify any date/timestamp after 2:00 PM The timestamp is formated as:
m/dd/yyyy hh:mm:ss AM/PM
Any help would be appreciated.
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=IF(MOD(A1+0,1)>14/24,"higher","lower")
Return to General Excel Questions
Users browsing this forum: No registered users and 245 guests