TIME and IF Function: over 23:59:59

[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.

 

[Jason Morin]

One way:

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

HTH
Jason
Atlanta, GA

 

[Daniel.M]

Hi,

... but do not know how 12:30am can be represented:

TIME(0,30,0)
or
1/48


BTW, TIME(12,30,0) is 12:30 pm

Regards,

Daniel M.