Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I had a 24 hours data starting from 20/10/2013 12:00 AM to 21/10/2013 12:AM
Now i need to split this into 3 slots
Please help me how to acheive this.
Try Class() function.
can you please let me know how to do it?
Hi.
you can try interval match fuction, you can search example on help.
regards
I would use
If(Frac(time)>9/24 and Frac(time)<=18/24,'9AM-6PM',
If(Frac(time)>18/24 and Frac(time)<=24/24,'6PM-12AM',
'12AM-9AM')) as Shift
HIC