Forum Discussion
Keeping track of trip times
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...
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