Formula To Calculate Speed Knowing Distance, Destination Time And Checkpoint Times
Dec 2, 2008
On my spreadsheet i have a bunch of variables:
A1 = Arrival time at Checkpoint 1 - 5:53:08
A2 = Time to destination from Checkpoint 1 - 1:10:18
B1 = Arrival time at Checkpoint 2 - 6:00:56
B2 = Time to destination from Checkpoint - 1:02:30
C1 = Total distance from Start - 2.83
C2 = Arrival Time at Destination - =SUM(A1,A2)
D1 = Speed determined from the other variables
D1 is SUPPOSED to equal 25.00
It also is where I am stumped!!
Not only can I not figure out the math but also how to format the function to get the right answer.
ps: Arrival Time at Destination is only included in case it would be useful to find the answer!
View 7 Replies
ADVERTISEMENT
Aug 6, 2014
this is normally a very simple thing to calculate and I know how to calculate for speed, distance and time or SoDiT as we learnt at school..
I have a period of time where a distance in feet is covered. Lets say 1 hour 25 minutes to cover 12,600 feet, just over two miles.
What I need to solve for in this case is not speed exactly, but how long it takes to cover 10 feet in this scenario.
I start to do the math in excel and then the formatting jumps when I set to hh:mm:ss and I get confused whether I'm multiplying or dividing by 60 and it all becomes a mess.
View 4 Replies
View Related
Feb 17, 2013
I have 3 numbers:
1) Current Speed
2) Current Acceleration
3) Acceleration Growth
Assuming:
Current Speed=0
Current Acceleration = 0.2 (each 'turn' the current speed will increase by this much)
Acceleration Growth = 0.2 (each 'turn', the current acceleration will grow by this much)
This gives a current speed over a series of 'turns' as
0.0 + 0.2 = 0.2
0.2 + 0.4 = 0.6
0.6 + 0.8 = 1.4
1.4 + 1.0 = 2.4
2.4 + 1.2 = 3.6
3.6 + 1.4 = 5.0
5.0 + 1.6 = 6.6
6.6 + 1.8 = 8.4
8.4 + 2.0 = 10.4
etc.
What I'd like to do is have a formula (or some way other than calculating each step) to tell me how many turns it would take for the Current Speed to =>X (example 100)
Basically, Turns to X speed = something clever * acceleration growth * something else very clever.
View 9 Replies
View Related
Jul 7, 2009
I have a excel sheet with city names in Column A, Distances in Column B, and Distances in Column C.
I wanted to write a formula so excel checks the distance between column C and column B and if there is less than a 10% difference between the two then it would copy the name of that city into another column D.
View 4 Replies
View Related
Apr 8, 2014
I'm looking for a formula that will calculate the difference in times between specific times while working with a 24 hr clock. Please see details below:
E3 provides the start time of 4:00
H3 provides an end time of 15:30
If an employee works betwen the hours of 0:00 (midnight) to 5:59, this is considered DIFF hours and is therefore the number I am seaking. So for the data noted above, the total DIFF hours worked is 2 hours.
View 7 Replies
View Related
Apr 28, 2014
I am looking for a way to calculate the average time, over a number of times.
So basically, would have different times in 24 hour hh:mm:ss, all in column i.
I have tried =AVERAGE(i2:i18) and it doesn't work.
I have also tries Ctrl/Shift enter as an array, it didn't work.
I tries to format cells as time and number, it didn't work!
View 1 Replies
View Related
Feb 7, 2008
I'm trying to calculate whether a time value located in a cell is between the times in two other cells. Here is what I tried:
=IF((AND($A62>=C$55,$A62
View 9 Replies
View Related
Nov 14, 2008
Need a ormula that will calculate various lengths of time within a column.
For example: I would like to be able to add
02:43 (2 minutes 43 seconds) plus
01:10 (1 minute 10 seconds) plus
05:15 (5 minutes and 15 seconds)
..and accurately arrive at the sum of
09:08 (9 minutes 8 seconds)
Currently, whenever I input the value of 02:43- and assign the value of 'TIME'.. it reads it as 14:23 (clock time..not length of time.) I will only be using data that follows the format of mm:ss (minutes:seconds).
View 2 Replies
View Related
Aug 15, 2007
I need to create a formula to calculate monthly hours worked (144.20) by hourly rate (£14.25). So far everything ive tried has given me awrong answer. I cant seem to make the total right. From what ive come up with (Not good) the total accepts the hours-just not the minutes.
View 8 Replies
View Related
Mar 25, 2014
How to calculate overlapping times. I have found a few formulas on here I have tried to reproduce with no luck. This thread is similar to my issue.(How to calculate the amount of overlapping time) I need a non VBA format.
I need to know what times are overlapping; I need to see when two people are working active cases at the same time and how much time is overlapping. This is a huge spreadsheet with several rows of data. At this moment I am dong it all manually.
Here is a sample of what is looks like. As you can see the first line is overlapping with the second line by 8 minutes into the next case.
NAME
DOS
Start time
End Time
Person A
2/3/14
6:40
7:38
[Code] .....
View 1 Replies
View Related
Dec 5, 2007
I want to use a User Defined name look up its corresponding X/Y Coordinates , reference a list organized by categories, then go through each name in the list finding each's X/Y Coord Calculate distance.
SQRT((X-X)*(X-X)+(Y-Y)*(Y-Y))
where X and Y are Coordinates
& Return the name of the smallest Value.
View 9 Replies
View Related
May 14, 2013
I need a formula to calculate hours worked between specific times. In the worksheet I have, I need to calculate the hours worked between 5am and 10pm, the start time is in C7, and the finish time in D7 the formula need to be in H7, and another formula in I7 to calculate hours worked before 5am and after 10pm .
C
D
F
H
I
Start
Finish
Total
Ordinary
20%
4:00
23:00
19:00
17
2
View 9 Replies
View Related
Oct 22, 2011
Excel to calculate distance in miles between post codes
Is there anyway of doing this?
View 4 Replies
View Related
Apr 27, 2014
Formula to calculate time allotted minus time used and show the difference in hour and minute.
View 1 Replies
View Related
Jul 1, 2012
I have a problem here:
Eg.
A B C D E F G H I
1 8 pm 9 pm 10 pm 11 pm 12 am 1 am 2 am
2 8 pm 11 pm
3 8 pm 2 am
I typed a formula : =if(and(c$1>=$a2,d$1
View 4 Replies
View Related
Aug 14, 2007
I need some IF formula I believe that will yield an answer between 1 - 5. I'm not swavey enough with these things to figure this one out... trust me I tried and it keeps getting more confusing for me.
If the time worked is between certain time criteria then it would equal 1 - 5 depending on the time.
Example: If I work between the hours of 5am and 1pm then I would be in the Open/Mid range and would need to equal 2. If I only worked a few hours and my hours fell only between the Mid range then it would equal 3.
Then based on that... It would automatically fill in on the deployment charts... My name would show up on the Open and Mid Deployments under the task chosen for me to do that day.
I've attached a small sample of what I am looking for to kind of help show what I need. The highlighted areas are the areas I'm not sure how to do.
View 9 Replies
View Related
Apr 8, 2007
formula to work out a variance between two times
Using the 24hr time format in cell a1 i have a start time of 10:43 and in cell b1
i have an estimated time i think a job should take in this case 30 minutes and in cell c1 i have the actual time that job was finished in this case 11:07 and in cell d1 i have a variance between the two times which in this case would be saving me 6 minutes
View 9 Replies
View Related
Mar 20, 2007
I have a nifty formula brought to me by one of the excellent members on this board. It works perfectly for what I want, but I must admit I cheated, I have a problem that was similar to the problem this formula rectified and I find myself not knowing how it works.
=IF('IIC Transfer Status'!O139="x",MIN('IIC Transfer Status'!K139+10-WEEKDAY('IIC Transfer Status'!K139-{1,3})), "" )
What Im wondering is if someone could enlighten me as to what is happening in this function, so Im not as blind to assume it is magic.
Eventually I need it to be customed tailored to work in this way: I have a column of dates, I want it to look at column A and if there is a date in it ADD 4 WEEKDAYS (business days) and return the resulting date.
i.e date in column a is march 19 plus 4 business days. Result in column B march 23.
If someone can explain how this string works that would be great, or if someone could just post a suitable function, that would work for now.
View 9 Replies
View Related
Nov 30, 2013
I am attempting to create a formula that will count the number of times, lets say letter A, occurs in column E. However, the tricky part that I have been confused on is that I only want to count how many times A occurs between each hour of the day. I need to count number of times "A" occurs between each hour of the day for the entire month.
My Worksheet looks as such: Column A contains the dates for the month of November, Column B contains times that random instances occur, Column C is not important, Column E contains a Letter A-N that pertains to what occurred at a time in column B. SO, Column B and column E coordinate with each other.
Here is an example. Column A - Cell A1 - 11/01/2013 , A2 - 11/02/2013, A3 - 11/03/2013.
Column B - Cell B1 - 12:01 AM , Cell B2 - 14:03 , Cell B3 - 15:23
Column C - Cell E1 - A , Cell E2 - A, Cell E3 - B
So I would like Column F to display that between 12:00 - 12:59 Am there was X number of times the letter A occurred throughout the entire month.
View 4 Replies
View Related
Aug 13, 2012
Below is my data
Complexity Type
Name
1
2
3
4
5
6
7
Ali,Shaheen Sultan
8
34
34
6
0
0
0
Budati,Manoj Kumar
7
18
18
12
6
0
0
Based on above data if The Column heading is 1 then it needs to go to the below data and multiply by that value and at the end should give me the total for the person. note that the total time is captured in a different sheet.
Complexity
Times Complexity 1
1
1.00
2
1.41
3
2.03
4
2.92
5
3.19
6
4.10
7
4.65
View 6 Replies
View Related
Feb 24, 2014
I want to calculate time left in hours from today to target date. The result should be exclude weekend/holidays and non-working hours too.
View 3 Replies
View Related
Feb 16, 2010
I have been asked to make some ammendements to a workbook currently in use.
I have to calculate elapsed time, and my formula is giving me odd results. I have a start time (cell B5), and an end time (cell F5). The formula being used was =IF(F5>0,((F5-B5)*24)) which gave the correct result. The cell is formatted as general. It didn't alot for the situation where the end time has not happened yet.
I changed the formula to =IF(F5>0,((F5-B5)*24),(K5-B5)*24) where cell K5 is the current time. The results are coming out with 6 - 9 decimal places. It makes no sense as I've tried setting the times to be exactly 24 or 48 hours to the minute. I've also tried replacing K5 in the formula to now(),
View 12 Replies
View Related
Aug 23, 2012
I want to calculate labour rates as follows:
06:00 to 18:00 std rate $10
18:00 to 06:00 night shift rate $15
I want to be able to type in the hours worked e.g. 11:00 to 19:00 and would expect 7hrs at $10 and 1 hr at $15.
View 1 Replies
View Related
Feb 17, 2008
I'm working in excel2007:
I want to write a generic formula to calculate the difference of time between cells, the first being a real data point, such as
6/22/2007 8:53
minus a generic constant term using the same date and a given time, 8:30.
So, what I need is something like this:
6/22/2007 8:53 – (same mm/dd/yy @ 8:30)
6/22/2007 12:29 – (same mm/dd/yy @ 8:30)
6/25/2007 11:19 – (same mm/dd/yy @ 8:30)
View 9 Replies
View Related
Aug 7, 2007
attached is an example of a timesheet we use.
now after lengthy discussions the comany say its not 'in their interest' to use acess so i'm stuck with excel on this one.
I need to sum a column on many critiera, which i feel maybe a job for the trusty old =SUMPRODUCT. But thing is i need to sum a column based on a date range, Rate, Day.
I have manually typed in the number i think it should produce but as far as formulas go
1st off need to calcualte date range, which is situated on the top of the spreadsheet.
2nd some how tell the formula that Normal overtime is either classed as rate 1 Saturdays classed as 1.5 and sundays and bank holidays classed as 2.
View 3 Replies
View Related
Jan 8, 2013
I have recorded 7 different macros and then combined them all into one macro to achieve one end result. I am not sure if you can just look at the codes to determine different ways to improve them or if you need the excel spreadsheet as well.
View 2 Replies
View Related
Jun 8, 2014
I am a flight dispatcher who is having difficulty with a Flight Duty Period tracking sheet. I need a formula which gives me the total duty time of a pilot in one single day, which is calculated by using the DUTY START time of first flight and DUTY END time of last flight in the same day.
I have attached the excel file. Please download file and open the FDP tab from the file and goto cell AI7.
Basically I need a formula in cell AI7, which checks up the date on column D and selects a date range of the same date in column D (in this case D7:D8) and then give the difference between the Duty Time START of FIRST FLIGHT (column AF) and Duty Time END of the LAST FLIGHT (column AG).
Ex: 12:05-9:20 =2:45
Please note that I want the formula to automatically check the cells in column D for the dates, not manually select the dates, because pilots do more than one flight per day sometimes and it is never same. Formula than should be able to calculate the difference between the largest number in column AG and lowest number in column AF in the same date range mentioned before.
Uneven number of flights on different days is making it complicated for me.
View 2 Replies
View Related
Feb 12, 2010
I am using the below formula to distinctly count the number of customers that match the criteria that I have in Cells C7 and B10. The data is in a separate worksheet, that I am showing Named Detail of which will be changing on a monthly basis, so a pivot table does not want to be used. The detail data ranges from row 7-40,000, and the file is currently 8610KB's, and can potentially grow.
=SUM(IF(FREQUENCY(IF(Detail!$A$7:$A$40000=C$7,IF(Detail!$B$7:$B$40000=$B10,IF(Detail!$D$7:$D$40000<> "",MATCH(Detail!$D$7:$D$40000,Detail!$D$7:$D$40000,0)))),ROW(Cust)-MIN(ROW(Detail!$D$7:$D$40000))+1),1))
This formula works but takes an excessive amount of time for one caluclation, and I need this for multiple column and row critera. So, can this calculation be changed in order to get the same result with faster calculation time? I am using Excel 2003.
View 6 Replies
View Related
Apr 14, 2013
I want to fill all a column bottom-up but without specify cells in format "A1500:A2" like
VB:
Range("H1578").Select
Selection.AutoFill Destination:=Range("H2:H1578")
{H1578 have a formula so...}
I have data in the first 7 columns, with a variable(Range) for the first 5 columns
VB:
Dim oRange As Range
Set oRange = ActiveSheet.Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(89, 4))
{The first cell in it is A1}
My question is : How to fill Range("H2:H1578") using my ''oRange'' variable?
I try with OffSet but my code didn't work. I need to do the same with the 6 columns to the right and then plot in a chart.
View 4 Replies
View Related
Nov 22, 2008
Havent used a spreadsheet in ages and i'm having a fun time here. Cant seem to get the right formula for what i need. Here is a brief explanation!
I have a grid (not related to excel) of 999 by 999 squares.
The center is basically co-ords 500|500.
Upper left would of course be co-ords 001|001
Upper right would be 999|001
Bottom left would be 001|999
Bottom right would be 999|999
Now, here is what I am trying to do:
I want to have 3 squares chosen out on a spreadsheet I have made . .
1) here i put in the start co-ords (ie: 500|500)
2) here i put in the destination co-ords (ie: 505|510)
3) This is the fun one!!! ... And where I need the help!
I need a formula to put here that will tell me the number of squares I have to cross to get from one to the other!
View 9 Replies
View Related
