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.
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
formula needed.
2 posts
• Page 1 of 1
Re: formula needed.
by pecoflyer » Thu Mar 10, 2016 10:45 am
Hi and welcome
supposing your date and time is in A1 try
supposing your date and time is in A1 try
- Code: Select all
=IF(MOD(A1+0,1)>14/24,"higher","lower")
- 0
A relevant topic title helps get faster and more answers
- pecoflyer
- Moderator
- Posts: 1274
- Joined: Jan 24, 2012
- Location: Belgium
- Reputation: 39
- Excel Version: 2003/2007/2010
2 posts
• Page 1 of 1
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 128 guests