Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramu_i
Creator II
Creator II

Find the Avg time

Hi Team,

I have Restraint name and Time is there find the avg  working hours of restraunt.

Time data having 

Timing
8:30am – 10:30pm (Mon-Sun)
12:30PM to 12Midnight (Mon, Wed, Thu, Fri, Sat, Sun), 1PM to 12Midnight (Tue)
9:30 AM to 11 PM
8am – 11pm (Mon-Sun)
11:30 AM to 11:30 PM
10:57 AM to 11 PM
11am – 10:35pm (Mon, Tue, Wed, Fri, Sat), 11am – 10:30pm (Thu),11am – 10:45pm (Sun)
10:57 AM to 11 PM
9 AM to 9 PM
12midnight – 1am, 11:30am – 12midnight (Mon-Sun)
4pm – 1am (Mon-Sun)
8:30am – 10:30pm (Mon-Sun)
11 AM to 11 PM (Mon-Sun)
10:30 AM to 11:30 PM (Mon-Sun)
10 AM to 11 PM (Mon-Sun)
10:57 AM to 11 PM
12 Noon to 4 PM, 7 PM to 11:30 PM
10 AM to 11 PM (Mon-Sun)
8 AM to 11 PM (Mon-Sun)
1pm – 10pm (Mon-Sun)
8 AM to 10:30 PM (Mon-Sun)
11 AM to 11 PM
12 Noon to 11:30 PM (Mon-Sun)
10am – 3am (Mon-Sun)
10:30 AM to 11 PM (Mon-Sun)
11AM to 3:15PM, 7PM to 10PM (Mon-Sun)
11 AM to 11 PM
1PM to 12Midnight (Mon-Sun)
10:57 AM to 11 PM
12noon – 12midnight (Mon-Sun)
11 AM to 10 PM (Mon-Sun)
1:5pm – 10:50pm (Mon-Sun)
8 AM to 10 PM
24 Hours
12Noon to 11:55PM (Mon-Sun)
12noon – 1am (Mon-Sun)
12 Noon to 11:30 PM (Mon-Sun)
7 AM to 10 PM
12 Noon to 11:30 PM
10am – 11pm (Mon-Sun)
8am – 2am (Mon-Sun)
11 AM to 12 Midnight
11 AM to 12 Midnight
10:57 AM to 11 PM
3 PM to 12 Midnight
11am – 11pm (Mon-Sun)
11 AM to 11 PM
12:40pm – 11:45pm (Mon, Wed, Thu, Fri, Sat, Sun), 5:45pm – 11:45pm (Tue)
5 PM to 11 PM
11 AM to 11 PM
12:30 PM to 11 PM
11am – 3:30am (Mon-Sun)
11 AM to 10 PM (Mon-Sun)
10:30 AM to 10 PM (Mon-Sun)
11 AM to 11 PM
1pm – 11pm (Mon-Sun)
12 Noon to 11 PM (Mon-Sun)
12:30 PM to 2:45 PM, 7 PM to 11:45 PM
2 PM to 12:30 AM
12noon – 11:30pm (Mon-Sun)
10 AM to 11 PM
8 AM to 11 PM (Mon-Sun)
12Noon to 11PM (Mon-Sun)
8 AM to 3 AM
10 AM to 9 PM (Mon-Sun)
5pm – 11pm (Mon-Sun)
12:30 PM to 11 PM
10 AM to 11 PM (Mon-Sun)
11:30 AM to 3 PM, 7 PM to 11 PM (Mon-Sun)
10 AM to 11 PM
8 AM to 10 PM
12noon – 11pm (Mon, Wed, Thu, Fri, Sat, Sun), Closed (Tue)
12 Noon to 10:45 PM
11 AM to 11 PM
11 AM to 10:45 PM
1 PM to 11:30 PM (Mon-Thu),1 PM to 12:30 AM (Fri-Sun)
7:30 AM to 10 PM (Mon-Sun)
8 AM to 11 PM (Mon-Sun)
11 AM to 11 PM
12Noon to 11:30PM (Mon-Sun)
11 AM to 11 PM (Mon-Sun)
8 AM to 10:30 PM
12:30pm – 10:45pm (Mon-Sun)

 

Time field haves this type of data, How to find the Avg working hours of restraunt.

 

Thanks advance.

Ram

 

1 Solution
1 Reply