I drive for Uber as my only job and I'm trying to keep track of my trips on a spreadsheet. I've got formulas all set up for tracking miles, pay, fees, etc. but I'm having some difficulty figuring out a formula to track my time on trips. Basically, I need a way to input my time into my table and have to total time caculated in my TOTAL ROW at the bottom of said table. Any suggestions?
Uber gives me the elapsed time for each trip in hh:mm:ss
For example, trip 1 is for 15 mins and 34 secs. I have a column in my table for trip time. I'm having the issue of how to format the column (how to enter the time into the table) and then what formula to use in the total row at the bottom of the table to add up all my travel time for the month.
I'm not sure if that makes sense or not. Thanks for any help!
Not sure I understand what's an issue her. If you have your times column formatted as [hh]:mm:ss you may enter each trip time as 0:15:34 for trip 1, etc. and for the SUM() it'll be like 149:23:14. Or you'd like to have in some other format?
Formula for the total could be SUM, SUMIFS, SUBTOTAL - depends on how your data is structured