In: Computer Science
this is in excel VB8
Program 3: Long-Distance Calls A long-distance provider charges the following rates for telephone calls: Rate Category Rate per Minute Daytime (6:00 A.M. through 5:59 P.M.) $0.07 Evening (6:00 P.M. through 11:59 P.M.) $0.12 Off-Peak (12:00 A.M. through 5:59 A.M.) $0.05 Create an application that allows the user to select a rate category and enter the number of minutes of the call, then displays the charges. Use the following test data to determine if the application is calculating properly: Rate Category and Minutes Charge Daytime, 20 minutes $ 1.40 Evening, 20 minutes $ 2.40 Off-peak, 20 minutes $ 1.00 1) Time Calculator Create a application that lets the user enter a number of seconds and produces output according to the following criteria:• There are 60 seconds in a minute. If the number of seconds entered by the user is greater than or equal to 60, the program should display the number of minutes in that many seconds. • There are 3,600 seconds in an hour. If the number of seconds entered by the user is greater than or equal to 3,600, the program should display the number of hours in that many seconds. • There are 86,400 seconds in a day. If the number of seconds entered by the user is greater than or equal to 86,400, the program should display the number of days in that many seconds.
this is in excel VB8