TIME and IF Function: over 23:59:59

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

Jason Morin

One way:

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

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculated minus breaks & lunch 2
TIME and IF function 2
Average of Day and Time 3
Converting EST time in IST 1
Sum based upon matching data in different columns 1
help with subtracting time excluding weekends and non-working hour 2
Calculation of Hrs and Mins from 2 Time Frames 6
IF statement with time over midnight 3

Top