## (Solved) A movie theater has a normal ticket price of \$12. For shows that start between 7 pm and 1 am, there is no discount. For shows that start at other...

A movie theater has a normal ticket price of \$12. For shows that start between 7 pm and 1 am, there is no discount. For shows that start at other times, there are special prices for the following age ranges: individuals whose age is under 12 pay only \$8; individuals, whose age is between 12 and 16 inclusive, pay only \$10; individuals whose age is 65 or over pay \$9.50. Write a VBA function that gets the individual's age from the worksheet and returns the ticket cost. Your function can get the current time of day in hours (on a 24 hour clock) by a statement like timeHr = Hour(Now). For example if the time was between 7 pm and 7:59:59 pm, the statement timeHr = Hour(Now) would return a value of 19.
This text was automatically generated from the attachment. Please refer to the attachment to view this question.
This question was created from Quiz 4 Solutions https://www.coursehero.com/file/9114485/Quiz-4-Solutions/?focusQaId=10356850

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 05, 2019

Solution~000200122648.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 05, 2019

EXPERT

Tutor