Re:Time

[Chanty4u]

hi ,

Need help.

PFA

my reuirment is from  ORDER_BOOK  field i want above 60min between10&30min,between 30&45min

using if Else condition ony nt usng interval match fun

Thank you

suresh

[sasiparupudi1]

if (ORDER_BOOK_TO_OSN_TIME<10,'less than 10 minutes',if(ORDER_BOOK_TO_OSN_TIME>=10 and ORDER_BOOK_TO_OSN_TIME<=30,'between 10 & 30 minutes',if(ORDER_BOOK_TO_OSN_TIME>30 and ORDER_BOOK_TO_OSN_TIME<=45,'between 30 & 45 minutes',if(ORDER_BOOK_TO_OSN_TIME>45 and ORDER_BOOK_TO_OSN_TIME<=60,'between 45 & 60 minutes',if(ORDER_BOOK_TO_OSN_TIME>=60 ,'above 60 minutes'))))) as Interval