Find the Avg time of Hotel openings

[Ramu_i]

Hi All,

We have data like Hotel ID and Time

Time column having this type of data

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

According to this time how to calculate the Avg hotel opening time.

Thanks advance.

Ram

[eronevil]

Use AVG functio

Avg - chart function | Qlik Sense on Windows Help

[anat · Accepted solution]

first split the Timing field into 2 fields like 

for example :9:30 AM to 11 PM time as below

start time ,end time,interval

9:30 AM , 11 PM,13:30

then calculate the average of interval field

[JazleneAndrews · Accepted solution]

It's great that you're working with hotel data! To find the average time of hotel openings, you'll need to aggregate the time column and calculate the mean. When you're not crunching numbers, remember to take a break and explore the best place to stay in Miami. There are some fantastic options!