Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-864119%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-864119%22%20slang%3D%22en-US%22%3ECan%20I%20create%20a%20formula%20to%20output%20a%20time%20based%20on%20a%20start%20time%20of%200800%20and%20distance%20travelled%20at%20a%20certain%20speed%3F%3CBR%20%2F%3EEg%20start%20travelling%20at%200800%20at%2019.3121km%2Fph%20the%20first%20junction%20is%20at%200.4km.%20I%20want%20a%20formula%20to%20work%20this%20out%20and%20add%20it%20to%200800%3CBR%20%2F%3EAnswer%20is%201min%2014%20so%2008%3A01%3A14%20but%20how%20do%20I%20make%20a%20formula%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-864119%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-864146%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-864146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412111%22%20target%3D%22_blank%22%3E%40James_Sullivan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20a%20comment%2C%20that's%20not%20exactly%20the%20Excel%20question.%20If%20you%20have%20a%20logic%20how%20the%20result%20shall%20be%20calculated%2C%20expressed%20in%20words%20or%20with%20on-paper%20formulas%2C%20this%20community%20help%20translate%20it%20into%20Excel%20formulas.%3C%2FP%3E%0A%3CP%3EHowever%2C%20perhaps%20someone%20knows%20the%20answer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-866773%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866773%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412111%22%20target%3D%22_blank%22%3E%40James_Sullivan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGiven%20the%20Speed%20(kph)%2C%20Junction%2C%20and%20Distance%20in%20Columns%20A%3AC%2C%20the%20formula%20in%20D2%20of%20the%20attached%20file%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DSUM(IF(ISNUMBER(D1)%2CD1%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EF%242)%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EC2%2FA2%2F24)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
James_Sullivan
Occasional Visitor
Can I create a formula to output a time based on a start time of 0800 and distance travelled at a certain speed?
Eg start travelling at 0800 at 19.3121km/ph the first junction is at 0.4km. I want a formula to work this out and add it to 0800
Answer is 1min 14 so 08:01:14 but how do I make a formula
I have 100s of turns along a 200+ km route and have to also calculate those turns at different speeds
A formula would be a great help cheers
2 Replies

@James_Sullivan 

As a comment, that's not exactly the Excel question. If you have a logic how the result shall be calculated, expressed in words or with on-paper formulas, this community help translate it into Excel formulas.

However, perhaps someone knows the answer.

@James_Sullivan 

Given the Speed (kph), Junction, and Distance in Columns A:C, the formula in D2 of the attached file is: 

=SUM(IF(ISNUMBER(D1),D1,
F$2),
C2/A2/24)

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 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