Home

Keeping track of trip times

%3CLINGO-SUB%20id%3D%22lingo-sub-306005%22%20slang%3D%22en-US%22%3EKeeping%20track%20of%20trip%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306005%22%20slang%3D%22en-US%22%3E%3CP%3EI%20drive%20for%20Uber%20as%20my%20only%20job%20and%20I'm%20trying%20to%20keep%20track%20of%20my%20trips%20on%20a%20spreadsheet.%20I've%20got%20formulas%20all%20set%20up%20for%20tracking%20miles%2C%20pay%2C%20fees%2C%20etc.%20but%20I'm%20having%20some%20difficulty%20figuring%20out%20a%20formula%20to%20track%20my%20time%20on%20trips.%20Basically%2C%20I%20need%20a%20way%20to%20input%20my%20time%20into%20my%20table%20and%20have%20to%20total%20time%20caculated%20in%20my%20TOTAL%20ROW%20at%20the%20bottom%20of%20said%20table.%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-306005%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-306118%22%20slang%3D%22en-US%22%3ERe%3A%20Keeping%20track%20of%20trip%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306118%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20sure%20I%20understand%20what's%20an%20issue%20her.%20If%20you%20have%20your%20times%20column%20formatted%20as%20%5Bhh%5D%3Amm%3Ass%20you%20may%20enter%20each%20trip%20time%20as%200%3A15%3A34%20for%20trip%201%2C%20etc.%20and%20for%20the%26nbsp%3BSUM()%20it'll%20be%20like%20149%3A23%3A14.%20Or%20you'd%20like%20to%20have%20in%20some%20other%20format%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormula%20for%20the%20total%20could%20be%20SUM%2C%20SUMIFS%2C%20SUBTOTAL%20-%20depends%20on%20how%20your%20data%20is%20structured%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-306025%22%20slang%3D%22en-US%22%3ERe%3A%20Keeping%20track%20of%20trip%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306025%22%20slang%3D%22en-US%22%3E%3CP%3EUber%20gives%20me%20the%20elapsed%20time%20for%20each%20trip%20in%20hh%3Amm%3Ass%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20trip%201%20is%20for%2015%20mins%20and%2034%20secs.%20I%20have%20a%20column%20in%20my%20table%20for%20trip%20time.%20I'm%20having%20the%20issue%20of%20how%20to%20format%20the%20column%20(how%20to%20enter%20the%20time%20into%20the%20table)%20and%20then%20what%20formula%20to%20use%20in%20the%20total%20row%20at%20the%20bottom%20of%20the%20table%20to%20add%20up%20all%20my%20travel%20time%20for%20the%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20if%20that%20makes%20sense%20or%20not.%20Thanks%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-306019%22%20slang%3D%22en-US%22%3ERe%3A%20Keeping%20track%20of%20trip%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306019%22%20slang%3D%22en-US%22%3E%3CP%3EI%20believe%20Uber%20returns%20each%20trip%20time%2C%20not%20necessary%20in%20%3DEnd-Start.%20But%20the%20question%20is%20why%20to%20use%20TEXT%2C%20IMHO%20applying%20elapsed%20time%20format%20%5Bhh%5D%3Amm%20to%20the%20SUM%20is%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-306013%22%20slang%3D%22en-US%22%3ERe%3A%20Keeping%20track%20of%20trip%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306013%22%20slang%3D%22en-US%22%3E%3CP%3EI%20imagine%20you're%20inserting%20two%20datas%20with%20the%20hour%3A%20once%20when%20you%20start%20your%20trip%2C%20and%20one%20when%20you%20finish%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20let's%20say%2C%20travel%202%20is%20from%2002%3A40%20PM%20to%203%3A20%20PM%20and%20you%20have%202%20columns%20(C%20and%20D)%20with%20this%20datas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20first%2C%20you%20need%20to%20create%20a%20column%20E%20with%20the%20total%20time%20spent%20on%20the%20single%20trip%20(so%20it's%20D-C%2C%20in%20this%20case%20means%200%3A40).%3C%2FP%3E%3CP%3EThen%20if%20you%20use%20the%20SUM%20formula%20(or%20if%20you're%20using%20pivot%20table%20just%20add%20the%20total%20row%20at%20the%20end)%20and%20format%20the%20text%20as%20%3DTEXT(SUM(E2%3AE500)%3B%22%5Bhh%5D%3Amm%3Ass%22)%20will%20show%20you%20the%20total%20amount%20of%20hours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20what%20I%20thought.%20Obviously%20the%20yellow%20cells%20are%20at%20random%2C%20pls%20focus%20on%20the%20green%20ones.%3C%2FP%3E%3C%2FLINGO-BODY%3E
UberMoM
New Contributor

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

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.

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.

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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies