Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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!
Use AVG functio
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
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!