Every delivery app shows you a number per hour. It's the gross: pay plus tips divided by time online. It ignores the car. I built a spreadsheet for gig drivers that works out the real number, and these are the formulas behind it. They work in Excel and Google Sheets.

One row per shift

Keep the inputs small so you actually fill them in after a shift:

Date App Hours online Trips Pay Tips Bonus Miles

If you multi-app, use one row per app for the same shift and split the hours. Everything else is a formula:

Total = Pay + Tips + Bonus Per hour = Total / Hours Per mile = Total / Miles Per trip = Total / Trips Deduction = Miles × mileage rate Day = TEXT(Date, "ddd")

Enter fullscreen mode

Exit fullscreen mode

TEXT(date,"ddd") gives "Mon", "Tue" and so on. That one column gives you a best-days table later with no extra work.

Gross hourly vs real hourly

Real hourly takes off what the car costs you: gas, repairs, washes, the business part of your phone.…