• 460K Members
• 12.7K Online
• 557K Conversations

New Contributor

# 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 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?

4 Replies

# Re: Keeping track of trip times

I imagine you're inserting two datas with the hour: once when you start your trip, and one when you finish it.

So let's say, travel 2 is from 02:40 PM to 3:20 PM and you have 2 columns (C and D) with this datas.

At first, you need to create a column E with the total time spent on the single trip (so it's D-C, in this case means 0:40).

Then if you use the SUM formula (or if you're using pivot table just add the total row at the end) and format the text as =TEXT(SUM(E2:E500);"[hh]:mm:ss") will show you the total amount of hours.

I attached what I thought. Obviously the yellow cells are at random, pls focus on the green ones.

# Re: Keeping track of trip times

I believe Uber returns each trip time, not necessary in =End-Start. But the question is why to use TEXT, IMHO applying elapsed time format [hh]:mm to the SUM is enough.

# Re: Keeping track of trip times

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!

# Re: Keeping track of trip times

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies