Answered step by step
Verified Expert Solution
Question
1 Approved Answer
((((((((((((((((((((((Excel)))))))))))))))))))))))))))))))))) Create a Userform to add the following information Date -Start Time -End Time -Hours -Start Mileage - End Mileage -Trips Gross -Tips HRS MILES
((((((((((((((((((((((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 FUEL TIPS NET NET/HR NET/TRIP GROSS/HR $16.58 FUEL/GAL $2.88 TOTALS 58.08 1,283.00 100 $963.04 $168.12 $37.00 $831.92 $14.32 $8.32 Date Start End Start Time End Time Hours Mileage - Mileage Miles # Trips 4:00:00 PM 6:30:00 PM 2.50 19,108.0 19,159.0 51.0 Fuel Cost Per Gross Gross/Hour Gallon Toda Fuel Cost Tips 1 $7.67 $3.07 $2.93 $6.79 Net Net/Hour - Net/Trip $0.75 $1.88 01/16/19 $1.00 $1.88 01/17/19 2:30:00 PM 6:30:00 PM 4.00 19,159.0 19,253.0 94.0 5 $61.07 $15.27 $2.97 $12.69 $48.38 $12.10 $9.68 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 12:00:00 PM 12:15:00 PM 0.25 19,445.0 19,452.0 7.0 1 $5.27 $21.08 $2.81 $0.89 $4.38 $17.50 $4.38 01/19/19 01/20/19 01/21/19 1/22/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 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 01/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 1/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.45Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started