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
Highlighted
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
Highlighted

@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.

Highlighted

@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
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies