((((((((((((((((((((((Excel)))))))))))))))))))))))))))))))))) Create a Userform to add the following information Date -Start Time -End Time -Hours -Start Mileage - End Mileage -Trips Gross -Tips

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

((((((((((((((((((((((Excel))))))))))))))))))))))))))))))))))

Create a Userform to add the following information

Date -Start Time -End Time -Hours -Start Mileage - End Mileage -Trips Gross -Tips

HRS
MILES
TRIPS
GROSS
GROSS/HR
FUEL/GAL
FUEL
TIPS
NET
NET/HR
NET/TRIP
ТОTALS
58.08
1,283.00
100
$963.04
$16.58
$2.88
$168.12
$37.00
$831.92
$14.32
$8.32
Start
End
Fuel Cost Per
Date
Start Time - End Time
Hours
Mileage Mileage
Miles
# Trips
Gross
Gross/Hour
Gallon Toda Fuel Cost Tips
Net
- Net/Hour Net/Trip
D1/16/19
4:00:00 PM
6:30:00 PM
2.50
19,108.0
19,159.0
51.0
$7.67
$3.07
$2.93
$6.79
$1.00
$1.88
$0.75
$1.88
D1/17/19
2:30:00 PM
6:30:00 PM
4.00
19,159.0
19,253.0
94.0
$61.07
$15.27
$2.97
$12.69
$48.38
$12.10
$9.68
01/19/19
2:30:00 PM
6:30:00 PM
4.00
19,338.0
19,410.0
72.0
4
$50.83
$12.71
$2.85
$9.33
$41.50
$10.38
$10.38
01/20/19
12:00:00 PM 12:15:00 PM
0.25
19,445.0
19,452.0
7.0
$5.27
$21.08
$2.81
$0.89
$4.38
$17.50
$4.38
01/21/19
3:00:00 PM 6:00:00 PM
3.00
19,531.0
19,561.0
30.0
3
$21.23
$7.08
$2.85
$3.89
$17.34
$5.78
$5.78
01/22/19
3:00:00 PM 4:00:00 PM
1.00
19,590.0
19,625.0
35.0
3
$21.75
$21.75
$2.85
$4.53
$17.22
$17.22
$5.74
D1/23/19
3:00:00 PM
7:00:00 PM
4.00
19,636.0
19,688.0
52.0
10 $101.52
$25.38
$2.85
$6.74
$94.78
$23.70
$9.48
D1/24/19
3:00:00 PM
6:00:00 PM
3.00
19,688.0
19,802.0
114.0
4
$31.55
$10.52
$2.85
$14.77
$5.00
$21.78
$7.26
$5.45
Transcribed Image Text:HRS MILES TRIPS GROSS GROSS/HR FUEL/GAL FUEL TIPS NET NET/HR NET/TRIP ТОTALS 58.08 1,283.00 100 $963.04 $16.58 $2.88 $168.12 $37.00 $831.92 $14.32 $8.32 Start End Fuel Cost Per Date Start Time - End Time Hours Mileage Mileage Miles # Trips Gross Gross/Hour Gallon Toda Fuel Cost Tips Net - Net/Hour Net/Trip D1/16/19 4:00:00 PM 6:30:00 PM 2.50 19,108.0 19,159.0 51.0 $7.67 $3.07 $2.93 $6.79 $1.00 $1.88 $0.75 $1.88 D1/17/19 2:30:00 PM 6:30:00 PM 4.00 19,159.0 19,253.0 94.0 $61.07 $15.27 $2.97 $12.69 $48.38 $12.10 $9.68 01/19/19 2:30:00 PM 6:30:00 PM 4.00 19,338.0 19,410.0 72.0 4 $50.83 $12.71 $2.85 $9.33 $41.50 $10.38 $10.38 01/20/19 12:00:00 PM 12:15:00 PM 0.25 19,445.0 19,452.0 7.0 $5.27 $21.08 $2.81 $0.89 $4.38 $17.50 $4.38 01/21/19 3:00:00 PM 6:00:00 PM 3.00 19,531.0 19,561.0 30.0 3 $21.23 $7.08 $2.85 $3.89 $17.34 $5.78 $5.78 01/22/19 3:00:00 PM 4:00:00 PM 1.00 19,590.0 19,625.0 35.0 3 $21.75 $21.75 $2.85 $4.53 $17.22 $17.22 $5.74 D1/23/19 3:00:00 PM 7:00:00 PM 4.00 19,636.0 19,688.0 52.0 10 $101.52 $25.38 $2.85 $6.74 $94.78 $23.70 $9.48 D1/24/19 3:00:00 PM 6:00:00 PM 3.00 19,688.0 19,802.0 114.0 4 $31.55 $10.52 $2.85 $14.77 $5.00 $21.78 $7.26 $5.45
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Knowledge Booster
Running Time of Application
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education