Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 MrJanjua
		
			MrJanjua
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have a time field i wants to show time wise data with different range of time
Like
| 2:30 | 
| 4:00 | 
| 10:50 | 
| 12:25 | 
| 10:20 | 
| 19:35 | 
| 19:00 | 
| 19:20 | 
| 16:00 | 
| 20:50 | 
| 2:40 | 
| 18:45 | 
| 21:40 | 
| 20:30 | 
| 19:20 | 
| 21:00 | 
| 4:00 | 
| 4:30 | 
| 16:30 | 
| 1:15 | 
| 15:35 | 
| 22:45 | 
| 20:55 | 
| 18:00 | 
| 21:00 | 
| 08:00 | 
| 21:30 | 
| 23:00 | 
| 6:00 | 
| 19:50 | 
| 17:15 | 
| 20:15 | 
| 4:30 | 
| 20:00 | 
| 13:20 | 
| 14:40 | 
| 12:30 | 
| 18:30 | 
| 16:45 | 
| 21:25 | 
| 16:30 | 
| 16:30 | 
| 19:00 | 
| 4:30 | 
| 23:25 | 
| 20:00 | 
| 19:15 | 
| 19:40 | 
| 20:54 | 
| 8:15 | 
| 19:25 | 
| 23:55 | 
| 4:30 | 
| 4:00 | 
| 20:50 | 
| 20:20 | 
| 10:50 | 
| 22:30 | 
| 12:30 | 
| 18:20 | 
| 22:30 | 
| 23:00 | 
| 4:30 | 
| 20:30 | 
| 22:30 | 
| 16:30 | 
| 22:00 | 
| 19:00 | 
| 16:45 | 
| 22:30 | 
| 11:18 | 
| 14:00 | 
| 19:10 | 
| 20:30 | 
| 19:25 | 
| 20:20 | 
| 15:40 | 
| 2:00 | 
| 18:00 | 
| 17:12 | 
| 19:00 | 
| 20:00 | 
| 12:20 | 
| 16:00 | 
| 22:15 | 
| 20:40 | 
| 13:55 | 
| 13:45 | 
| 19:15 | 
| 20:00 | 
| 10:10 | 
| 11:00 | 
| 0:05 | 
| 9:50 | 
| 22:20 | 
| 7:55 | 
| 17:30 | 
| 20:25 | 
| 10:00 | 
| 13:00 | 
| 20:15 | 
| 11:53 | 
| 18:45 | 
| 4:30 | 
| 20:10 | 
| 20:50 | 
| 19:00 | 
| 9:50 | 
| 23:10 | 
| 3:00 | 
| 10:00 | 
| 8:10 | 
| 14:00 | 
| 21:20 | 
| 09:45 | 
| 10:45 | 
| 12:50 | 
| 22:00 | 
| 13:00 | 
| 3:30 | 
| 4:00 | 
| 0:15 | 
| 11:22 | 
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Since your buckets are not even in size, you may as well write this out as nested if() statements
if(Time >= '08:00' AND Time < '11:00', '8-11',
if(Time >= '11:00' AND Time < '14:00','11-14)) etc - nest as many if() statements as required.
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Since your buckets are not even in size, you may as well write this out as nested if() statements
if(Time >= '08:00' AND Time < '11:00', '8-11',
if(Time >= '11:00' AND Time < '14:00','11-14)) etc - nest as many if() statements as required.
