Calculate Time To Cover A Distance
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
ADVERTISEMENT
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
View Related
Jun 10, 2008
Calculate the weeks cover of current inventory based on a sales forecast. the forecast is in weekly buckets so I was thinking using some form of loop statement within the function which basically starts with the inventory figure then subtracts the forecast week by week until the inventory figure is less than the weekly forecast. I should then be able to divide the inventory by forecast and add back the number of loops to give me the weeks stock figure.
I have done this using if statements but it will only allow me to use 10 statements in the function and I need to do this for a full years worth of forecast.
Does anyone have a suggestion as This problem is becoming quite frustrating.
Here's an example of how the spreadsheet looks
Forecast103050205040Inventory 20019016011090400Weeks Cover6.05.04.03.02.01.0
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
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
Oct 22, 2011
Excel to calculate distance in miles between post codes
Is there anyway of doing this?
View 4 Replies
View Related
Mar 8, 2014
production01.png
I am trying to figure a way to search for a cell that has a specific date and time range. There are several cell titles pending on the activity. I want to find a cell that has a time ** 7:30-15:30 , 15:31-17:30, 17:31-20:30. The end result is to calculate the activity between those time periods based on the data cells.
Example
If the date searched time field ** the activity ranges is 1635 I need to split the time and credit the activity time in the 730-1530 time and the rest on the 15:31-17:30 time
I have been able to do it on a single labor group based on time alone, but when I try to add the DATE to it my numbers go null. Eventually i will need to add 11 labor groups daily for weeks at a time .
Excel 2007
View 3 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
Aug 28, 2009
I am wanting to calculate the the processing time for an order that takes place within normal business hours and workweek. A normal day is from 8:00 to 5:00 If a task is started at 2:00 PM Monday and finished at 10:00 AM Tuesday then the result should be 5 hours as I do not want to include any time outside of normal hours. I can figure out how to subtract dates and times but not how to bridge a day(s). My data is somewhat flexible as I have not started the project yet. I can use separate cells for the times and dates or have two cells that use both incorporate the date and time (8/27/09 2:00 PM) for start and end time or any other idea.
View 6 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
Jun 19, 2014
I have a userform that time stamps on my userform as soon as i open the form, is there a way that when I submit, that the amount of time that I was on the call to be put in my column on my worksheet as minutes?
View 2 Replies
View Related
May 17, 2014
I found this formula similar to other formula
NETWORKDAYS(D1,F1)-1)*"18:00"-"9:00")+IF(NETWORKDAYS(F1,F1),MEDIAN(G1,"9:00","18:00"),"18:00")-MEDIAN(NETWORKDAYS(D1,D1)*E1,"9:00","18:00")
By the way ....D1 = start Date
F1 = End Date
E1 = start Time
G1 = End Time
It's GREAT! But now I need include time from 6:00 a. m. to 10:00 p. m. (I already modified your formula:
(NETWORKDAYS(D1,F1)-1)*("22:00"-"6:00")+IF(NETWORKDAYS(F1,F1),MEDIAN(G1,"6:00","22:00"),"22:00")-MEDIAN(NETWORKDAYS(D1,D1)*E1,"6:00","22:00")) because are regular working hours in Colombia but:
1. All the days (Monday to Saturday) are working days
2. I just want to calculate the time in shifts, I don't specify the start date and end date. Example: 8:00 p.m. to 11:00 p.m. Result: 2 hours, because 1 hour is after 10:00 p.m.
This are two different options, so I need two separate formulas.
View 10 Replies
View Related
May 3, 2008
This may be a bit vague but here goes.
I have to calculate the difference between the start time and end time of a job. The only catch is, how can I avoid calculating "out of hours" time. So, if a job goes from 9am to 9am the next day, I want it to avoid calculating between the hours of 23:30 and 03:30.
Another example is if a job goes from 02:00 to 04:00, I want it to avoid the tim between 02:00 and 03:00.
If there is a difference in days, so the job goes overnight, how do I take that into consideration also.
View 9 Replies
View Related
Aug 16, 2008
I've got a time difference from 8:00AM - 12:30PM as 4.30 I'm trying to get the minutes, .30, converted into a 6 minute increment, .5. Is it possible to do this and if so how would it be done? Below is a chart of how the time is converted from 6 minutes increments into decimal form.
6 = 0.1 36 = 0.6
12 = 0.2 42 = 0.7
18 = 0.3 48 = 0.8
24 = 0.4 54 = 0.9
30 = 0.5 60 = 1.0
View 5 Replies
View Related
Aug 11, 2006
I'm trying to devise a formula to produce "days in inventory" based on the following data:
Date In
Date Out (which may be blank if cargo still here)
Todays Date
Days in Whse (which is the formula I can't figure out!)
It needs to work like this, date out - date in, unless date out is null. If date out is null, the result should be calculated based off of todays date - date in.
View 3 Replies
View Related
Feb 7, 2014
the vendor has a 21 hr working window; start from 7am and goes until 4am; Mon to Fri.
Here is a scenario:
- i request for a product information from a vendor on 3-Feb-14 8:00am (Monday)
- he replies with all of the product info on 6-Feb-14 12:00pm (Thursday)
can you find the time in above scenario consideration the working window?
Here is another scenario:
- i request for a product information from a vendor on 6-Feb-14 8:00am (Thursday)
- he replies with all of the product info on 11-Feb-14 12:00pm (Tuesday)
- Sat & Sun are days off but keep in mind that my Friday shift ends on sat at 4am so the networdays formula wont work.
View 2 Replies
View Related
Jul 17, 2008
What i need is someway of when ever these certain numbers:
75
85
87
95
are entered into any row on column 1, then are automatically blacked out and un readable untill the cell is changed to another number.
View 9 Replies
View Related
Feb 5, 2009
I need to calculate the time spent replying to my inquiries: I log the time I receive my inquiry as: 06/02/2009 09:23:00 in column A. I log the time I send my reply as: 07/02/2009 07:23 in column B. In column C, I need to put the Formula that will return the following result: 0 days 22.0 hours.
View 5 Replies
View Related
Oct 18, 2007
I am need to setup an IF Function to cover several columns. I need the function to be able to look at Column A, B, C, and D and see if any are blank. If any of these is blank I need the function to give "Pending". If all of these columns have a Y then I need the function to give me "Completed".
View 9 Replies
View Related
Jul 31, 2009
I have a workbook that has a cover sheet which contains the names of all the tabs in the workbook. I need to be able to change the names in the cover sheet and the names in the tabs to be change to whatever the corresponding cell in the cover sheet text is.
View 14 Replies
View Related
Jan 18, 2010
Is there any way that this bit of code can be combined to create a shape using dates that fall on weekends (that are listed in row2) and at the same time cover all rows up to the last Row used in a worksheet?
For instance, in the columns of Row2 we have many dates and we would have "16-Jan-10" in one column and "17-Jan-10" in another column (usually the next column) which are weekend dates. the shape should be created in the next row under the weekend date and cover the column all the way down to the last used Row (last Row contaning data).
With ActiveSheet.Shapes.AddShape( _
Type:=msoShapeRectangle, _
Top:=.Top, Left:=.Left, _
Width:=.Width, _
Height:=.Height)
.Placement = xlFreeFloating '
.Fill.ForeColor _
.RGB = RGB(Red:=192, Green:=192, Blue:=192)
End With
View 9 Replies
View Related
Jan 10, 2014
I wanted to work backwards from a weeknumber (as defined in Excel). In other words, given a week number (i.e. 5) what is the first date and last date of that weeknumber. These are the formulas that I came up with and they work fine.
Formula: [Code] ......
Ffor 1st of the week and
Formula: [Code] .......
For the last of the week.
Attached File : Weeknumber.xlsx
View 5 Replies
View Related
Apr 5, 2009
I have tried to make cartesian coordinates (X)and (Y) using excel 2007. now I want to represent some shapes (circles, squares, triangles, and so one). My problem now is with formating those shapes. I use this path (Insert > Shapes),, but the shape I add cover the grid,
I want (for example) a circle but I need only its circumference, and without covering the grid by its area. the same for other shapes.
View 3 Replies
View Related
Jan 17, 2013
CK Nursery and Finish Inventories.xlsxAttachment 207447
I would like the "Finish Summary by Age" tab worksheet to look like the "Nursery Master Sheet" and "Circle K 1 - CD Farms Nursery" tab worksheets. I'd like the "Finish Summary by Age" tab worksheet to cover the majority of the paper like worksheets on the other tabs.
View 1 Replies
View Related
Jan 21, 2013
I have 36 pages of names, addresses & contact info ETC that I want to print. I have a printer that offers a cover sheet in the print setup.
My list of names addresses ETC takes up two full pages of paper for each name. There are 16 columns across the sheet that contain data for each entry. I would like to print this so that I can turn the pages like an address book and see all of the data for a given set of contacts on each two page spread. So what I need to do is print the first half of the contact info on the inside of the first page and the second half on the next page and so on.
How can I set this up?
View 4 Replies
View Related
Feb 8, 2013
I have attached a workbook with various worksheets. the aim being to create a cover worksheet called "averages".
Every few days i will manually add a new worksheet in the same format as "332" i had to delete most of the data from "333" to meet the file size limit but you should still get the idea. I would like the "averages" worksheet to work out an average rating and pull the data for all competitors from all worksheets.
I All my data is obtained from 2 columns, USERS & rating which i manually copy paste to a new worksheet every few days from that info i build my basic pivot table. maybe i can gather all the USER & rating columns on the same page and use a more complicated pivot table and thus do away with all the worksheets completely? But I do like being able to easily compare each individual rating against the other competitors for that particular day.
Attached File : competitor ratings1.xls
View 1 Replies
View Related
Feb 9, 2009
However I only put in a small price list when i tried extending it the workbook produced error as per attached. I thought i would just need to amend the row numbers but it doesnt seem to work
unable to upload at present but prevoius is available on this thread. http://www.excelforum.com/excel-work...hoice-sum.html. Need to extend price list to cover up to 10,000 lines
View 5 Replies
View Related
Nov 17, 2007
I have drawn up a simple summary to show what I am trying to achieve: ...
View 9 Replies
View Related
Jul 20, 2013
I have a list A2...A11
In cell B1 is the following formula: =SUM(IF(FREQUENCY(IF($A$2:$A$11"",MATCH("~"&$A$2:$A$11&"",$A$2:$A$11&"",0)),Rvec),1))
Rvec is defined in NAME MANAGER as: =ROW(Sheet1!$A$2:$A$11)-ROW(Sheet1!$A$2)+1
In cells B2...B11 is this formula: =IF(ROWS($B$2:B2)
View 6 Replies
View Related
Aug 12, 2009
WHen I was a beginner at Excel, I came up with the following formula to calculate the time difference between two "time" values. Since I was too lazy to add a ":" between my hour and minute, I had decided to simply enter the start (column B) and end time (column C) as a military time (e.g., 0100, 1230, 1500, 1930, 2300, 2359). The following formula would be in Column D.
=IF(C7
View 9 Replies
View Related
