TIME and IF Function: over 23:59:59

  • Thread starter Thread starter Mediaexcel
  • Start date Start date
M

Mediaexcel

Hello,

I must say, this forum is a treasure!

Here is my question:

I have a column with various times, I have to categorize this time as
either Prime or Fringe

6pm-12:30AM is PRIME
12:30AM- 6AM is FRINGE

I have been trying this formula but do not know how 12:30am can be
represented:

=IF(AND(E4<TIME(24,30,00),E4>TIME(18, 0, 0)),"Prime","Fringe")

Thank you
S.
 
One way:

=IF(AND(A1>"12:30 AM"*1,A1<"6:00 AM"*1),"FRINGE","PRIME")

HTH
Jason
Atlanta, GA
 
Back
Top