Best Way To Graphically Show Results Of Time / Work Study
Feb 23, 2012
I am trying to determine the best way to graphically show the results of a time/work study. Basically i have a list of tasks and each list has 2 sets of numbers assigned to it. One for how much time it takes on a scale of 1-3 and a second for how much value is added for the task, again on a scale of 1-3. I want to show some sort of graph/visual that shows the number of tasks as clusters (not name of task) in maybe quadrants. With the time on X axis and value on Y axis. I am envisioning something like a 9 box that would have low/low to high/high. I can only think to create a 9 box in excel and physically put circles(clusters) in each quadrant.
View 2 Replies
ADVERTISEMENT
Jul 27, 2006
I am trying to create formula that will show overtime worked in a given day. The code I am using is a simple one ([ cell - 8], for hours worked). The problem is when the time cells are blank/not used it shows a -8 in the cell. what I need to do to create a code that will eliminate the -8 from showing. The cell its self is taking the result from another cell with a formula and then subtracting 8 from the result of the formula in the other cell.
View 2 Replies
View Related
Oct 20, 2009
I have built a formula using CONCATENATE. (Built in G2) When I copy and paste it into a empty cell (E2), one that is formatted as General and is not locked, as text or value or a formula I get the same results. It always shows up as text. I can't get the formula to function and show the results in the cell (E2). Yet, when I singularly build the formula in the cell it works fine. But the moving (cut and paste) from one cell to the other doesn't work.
The concatenated formula is: =CONCATENATE("=LEFT(",G2,",",H2,")") The result is: =LEFT(B2,3) . These results look fine, yet only when built in the cell using Excel's Insert Function builder or doing it by hand it works fine. It returns the first 3 numbers/text from the left side of cell B2. But the data that should result from the concatenated formula and pasted in to the cell (E2) is not showing up as needed. Any help would be appreciated.
View 11 Replies
View Related
Dec 14, 2007
I am created a very simple account plan for colleagues in my team which is proving to be very poular with the exception of one thing.
I created the plan which is around 30 sheets on my laptops highest resolution setting. 1400 x 1050. Only one other colleague has this res available so of course when the rest of the team open it, it looks huge.
I need help with this as I'm still very new to excel, although learning very fast!
My preference for finding a fix for this would be to insert a scroll bar on each sheet that, when scrolled, changes the zoom of the page between a range of 50% and 100%. This may not be the best way of doing it but I'm trying to make the sheets as simple to use as possible as some of my colleagues are only just compuetr literate, let alone excel competent!
View 9 Replies
View Related
Apr 26, 2007
I have Activity data from my production line that details when a job is running "RUN" and when its on stop "SETUP". It looks like this:
Run 0.45 hrs (decimal hours)
Setup 0.1 hrs
Run 1.2 hrs
Setup 0.2 hrs
etc.
I want to be able to graphically present this against a fixed timeline, I have the timeline in a column, (not a row). I have cumulatively summed my times so I have this...
Run 0.45 hrs
Setup 0.55 hrs
Run 1.75 hrs
Setup 1.95 hrs
etc
However I want to be able to establish whether the job was ON RUN or SETUP at each interval of my timeline. For example: if my time line was in 0.01 decimal minute intervals, my chart would look like this:.................
View 3 Replies
View Related
Jun 3, 2009
I have a work sheet with about 35,000 lines of data. Every day I have to sort the list by product category (I use auto filter to separate) and then copy the results into a new worksheet, there are about 300 product catagories. I'm new to macros but I'm wondering if there is a macro that can automate this process.
View 6 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
Apr 27, 2008
I'm writing an application for myself, running on Windows Vista & Office 2003, I have no intention, as things stand, of this being used on any other PCs or by anybody using an older version of Windows or Office. I am a Mainframe programmer so my logical way of thinking is not always in line with the best way of using VBA, but I try my best & seem to be getting by, but I have a problem & question as follows:
I "SHOW" a UserForm with an option to Add or Delete. I choose Delete & a new UserForm is opened, populated with data from an Access database, I choose my option from a DropDown box, click OK & I then want the data to be deleted and to return to the first UserForm. I "UNLOAD" the latter UserForm and then try to "SHOW" the original one, but get an error message saying "Form already displayed; can't show modally" ... the first port of call:
You can't use the Show method to display a visible form as modal. This error has the following cause and solution: You tried to use Show, with the style argument set to 1 – vbModal, on an already visible form.........
View 4 Replies
View Related
Feb 12, 2014
How can it be changed to show the results instead of in Column A, in say range E10?
Code:
Option Explicit
Sub InsertRows()
' hiker95, 09/28/2013
[Code].....
I believe the problem lies somewhere with the Resize bit of the code, which I do not know how to change to display the results in Cell E10 and down.
View 7 Replies
View Related
Feb 27, 2009
Split from How To Set Up A Spreadsheet The Right Way
Taking onboard what you suggested I have "rethought" the layout and it is now in a single table format. What had stopped me doing this previously was the fact that I was not able to show 7 days a week for 48 weeks in columns. However thanks to the transpose function all the data is now more user friendly (See Attached Workbook)
You mention the data should be quite easy to manipulate from here, any ideas as I am struggling with the concept of how to display the data in a time series. I assume that it will involve some form of lookup function referenced to the table of times, but thats as far as i can get.
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
Feb 14, 2007
I have a spreadsheet that holds salary information. At the moment it shows against each person the highest salary for a person of the opposite ***. What I would like to do is have another cell that shows the names of all people who have that salary.
E.g. if the highest comparable salary for someone of the opposite *** is 30000 then I would want a list of all the people with that salary.
Is it possible to do a look up that would show all the results that match certain criteria?
View 11 Replies
View Related
Dec 31, 2013
In column B I only want to show the results from Column A if the character count equals 3. In Column C I only want to show the results from Column A if the character count is greater than 3
Example:
Column A
ast
john
julie
tyw
nhy
frank
View 5 Replies
View Related
Oct 24, 2006
I have copy 65'000 formula text cells from a software and paste it to excel. But, the formula in cell is not activated. In order to activate the cell formula, I have to click on each individu cell and press enter to active it. But i got
65'000 rows of the similar cells. So, what is the quick way to all the text formula at the same time.
View 2 Replies
View Related
Apr 17, 2008
I'm currently working on a model that calculates the costs associated with various phases of a project. I want to allow the user to input the number of weeks that each phase requires as part of the calculations. The result will then be displayed horizontally in chronological order with the values associated with each phase underneath ex:
phase 1 phase 1 phase 1 phase 2 phase 2 phase 3 phase 3 phase 3
Through multiple lookups I've been able to get the data into this format:
phase 1 phase 1 phase 1
phase 2 phase 2
phase 3 phase 3 phase 3
What can I do to merge these series into one series that is in the order I desire (each phase will vary in length based on the user's input)?
View 3 Replies
View Related
Nov 3, 2013
I have three search boxes in XL , two are search from and to dates and the other is search be ref.
I can currently search by dates and ref but would like to show all records in the specified dates if the ref field is left blank.
I am using the query writer and referencing back to cells in XL. I don't use the wizard or SQL. I have tried many options and think I should be using a OR statement with a wildcard but can't seem to get the result, does the wildcard just show the blank cells in the actual data?
View 1 Replies
View Related
Sep 19, 2013
I have a big DB with several rows and columns.
Column B has several card numbers (e.i. 7987654345678)
Column C has a location name (e.i. madrid)
Column L has a date (the date is when the card was used)
What I want to do is identify the cards that appear more then twice on the same date and the same place.
Card Number
Location
Date
123
LOC
18/01/2013
[Code] .........
I would like through a macro or pivot to show me the results of the 2 last rows, because those are the only ones that are exactly the same.
I have excel 2007 running on Windows7
View 2 Replies
View Related
Sep 27, 2012
I am using a ComboBox in Excel 2007 in a UserForm. It is drawing on a row source which populates empty cells duplicates. How do I get the drop down box results to only show unique values and nonblank entries?
View 4 Replies
View Related
Jan 20, 2013
I have attached a portion of a schedule I have been asked to update to show when more hours are scheduled for a time period than are available on the schedule.
Each Dept.(Man. and DCC) has 16 hours available per day, M-F.
How can I chart or show somehow when a conflict arises? I need to outsource the excess time to another facility in a timely fashion.
Attached File: GKirbywork overload.xlsx
View 4 Replies
View Related
Jul 11, 2013
I'd like a calculation that gives me a total of 7.50 hours instead of 8:00 hours (I'm hoping to add up the time worked into a meaningful hour:minute format)
View 2 Replies
View Related
Apr 9, 2008
I have a project where I have to work out the value of cars over a period of time.
The cars depreciate at 36.9% per year over a 5 year period and I can't work out for the life of me how to create a formula in excel that give me the values at the end of each year.
Each car costs £10000 and I need to know what the value of each car is at the end of each year
View 9 Replies
View Related
Jul 24, 2009
I can't figure out how to do a proper formula for calculating time. For instance I have one column that says "Time In", the next is "Time Out" and the other is "Lunch Time". My calculation needs to be this:
Find the total hours between the Time In and Time Out and then Minus the lunch time to get total hours worked for the day. The only way I can get this to work is using 24 Hour time format. Is there another way?
View 3 Replies
View Related
Jan 14, 2009
I have a sheet that I want to calculate what time a shift starts based on a cell shading.
Basically Cells C6 and D6 need to be auto calculated based on the cells that are shaded from G6:L6
Look at the Attachment and you will see what I mean.
View 8 Replies
View Related
Jul 29, 2014
why is that I have the same time value but with different conversion results?
I have values in column A10:A26 with an average time of 00:00:38 result with converted value of 7052.04.
When I type 00:00:38 in Column A30, it gives me a result of 7139.37...
Why do I have different conversion results knowing that I have the same time of 00:00:38?
I Have attached a sample workbook.
View 14 Replies
View Related
Jan 1, 2010
I am pulling what hair i have left out of my head, I am a New Desk Officer for a Local Police Dept trying to set up a patrol report sheet, I need to have a return of "Mids", "Days", "Swings" to be displayed in the cell next to the one labeled "Shift" depending on the time of day. IE: 12am-8am = "MIDS", 8am-4pm = "DAYS" 4pm-12pm = "MIDS".
View 10 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
Oct 22, 2008
I need to enter a formula that calculates the time a report is received from the time it was recorded in our database. therefore, it needs to exclude non working hours. here are the fields:
A1 2008/10/10 16:30
B1 2008/10/11 09:30
C1 8:00
D1 17:00
A1 = report received
B1 = reported recorded in db
C1 = work day start time
D1 work day end time
Where the answer should = 2 hours.
I am not an experienced excel user and so far the only formula I have now is: =TEXT(B1-A1, "d:hh:mm")
And how do I account for weekends?
View 9 Replies
View Related
Feb 28, 2013
I can calculate total hours when a user enters a start date/time and a finish date/time. The kick is I only want to include hours from 2:00 PM to 12:00 AM (10 hour period). So assuming all the start and end times will be in this range, how can i calculate work hours over multiple days? For example: Start date/time = 2/26/13 2:30 PM and end date/time = 2/28/13 10:30 PM. I want my calculated hours to show 28 hours.
View 1 Replies
View Related
Aug 21, 2008
I am trying to figure out a way to count the minutes used from 8am-5pm Monday-Friday. I have this years worth of data. I would like to do it by month and by week and by day. I use office 08 for the mac and its my understanding that it doesn't have VBA. I would also like to be able to figure out if on a certain date a employee made over x amount of phone calls in a day. But have several employees. I have columns that are labeled date, employee, minutes used.
View 2 Replies
View Related
Dec 26, 2013
I'm having trouble at getting the overall fastest time to show up. There are tree racers in two heats. Also the times are set up like 0;00.000 because i cant get it to work like MM:SS:MS .
Daytona GTR34.xlsx
View 5 Replies
View Related
