X Axis Time - Display 24 Hours Making Everything Unreadable?
Dec 22, 2013
I'm creating a spreadsheet for anaesthesia monitoring. I have a table that calculates the time every 5 minutes (i.e. start time + 5 mins) for 3.5 hours and columns for heart rate, respiratory rate and drugs which is then plotted on a scatter graph. I've forced the major x-axis major unit to be 5 minutes.
Everything works fine for the first few values (1.JPG) then after 24 values it decides it wants to go crazy with the x-axis and display 24 hours (2.jpg) making everything unreadable. I would set the minimum manually but it obviously that will change depending on when the case starts. I can upload the file but it has some macros for other sections.
View 5 Replies
ADVERTISEMENT
Nov 25, 2009
I'm creating a calculator to determine the distance & travel time on a xy grid for a game. I'll share what I have so far to display the big picture. Here’s what I’ve accomplished so far:
#1) Cells A1 & B1 are dynamic, they are frequently changed so distance and time may be displayed. Cells A2 & B2 do not change.
#2) I use the following formula to determine the distance between cells, displayed in C2: =SQRT((A2-$A$1)^2+(B2-$B$1)^2)
#3) Next I multiply C2 by a number so that distance is measured correctly per unit type for this game. (I hide this column). Therefore, cell D3 has the following formula: =C2*20
#4) Now my problem, cell E3 - Correctly displaying time. I have the following formula in E3: =TIME(0,D2,0)
This works great!! That is until the time goes beyond 24 hours, then it rolls over. I've tried right clicking and setting the custom format of E3 to [hh]:mm, it still rolls over. I’ve also tried setting formatting to d:[hh]:mm, if I do this then the output time displayed is incorrect.
Ideally I would love a simple fix so that the time will roll over and show days. (I would like a display similar to d:hh:mm).
I’ve done a fair bit of research online and either I'm missing something simple or this is more complex than I thought. And not to make this any more confusing, but I would love whatever I accomplish here to be useable in compatibility mode ...
View 12 Replies
View Related
Aug 13, 2002
I would like to make a graph with an x, y and z axis. All of the choices that excel gives me are only x,y graphs. How can I plot a 3-axis graph?
View 9 Replies
View Related
Oct 10, 2009
When I am converting a time from Hours/Minutes to Hours/Tenths, Excel is not converting it consitantely. EXAMPLE: 1:15 = 1.25. When I format the cell to present only one place past the decimal point, sometimes the cell will round up to 1.3, and other times it will round down to 1.2. What am I missing?
View 3 Replies
View Related
Jan 29, 2010
Format Time Cell For Greater Than 24 Hours: Hours & Minutes Only .....
View 9 Replies
View Related
Apr 4, 2013
find a formula that will calculate the hours between the two below values but only take in to consideration the business hours (from 9 to 17) and exclude any weekends?
08/03/2013 13:32:00
02/04/2013 09:32:50
View 4 Replies
View Related
Jan 13, 2009
I am making a schedule and I would like it to take out a 30 min break if the hours worked is over 6 hours.
I have so far
A B
1 11:00 7:30
=24*(B1-A1)
Gives me 8 hours, I would like it to subtract the 30 minutes only ifthe sum is over 6 and not alter the sum if it is under 6.
View 9 Replies
View Related
Jul 11, 2014
A client buys 500 minutes of my time. In one week I spend 340 minutes on the account. I'd like a column to show Time purchased (say 500 Minutes) Time spent and a final section showing time left (but showing negative values in red)
I hope I've explained this ok but here is an illustration of what I'm trying to achieve in Excel 2011.
[URL] ...........
View 2 Replies
View Related
Jun 1, 2014
I'm trying to prepare a Gantt chart and I'm unable to display the start of month date in the x axis. Currently I'm able to display each month by giving an interval of 31 days, but I'm not sure how to display the start of month in the chart. Tried to add a secondary horizontal axis,but the secondary axis is not intersecting with the y axis and the grid is not getting aligned properly.
View 1 Replies
View Related
Feb 5, 2014
how to plot Multiple left Y axis display in Multiple draw line graph. Already I have created Right Y axis. I want to draw 4 Line graph in one graph 3 are Left Y axis and one is Right y axis.
View 1 Replies
View Related
Jun 24, 2008
I am making a program that needs some macro but I don't know much about it. There are a couple of things I am trying to accomplish and I'm supposing it would be easier to let you look at the actual program so I uploaded it.
In the drop down boxes in column C there are trucking companies listed. Each trucking company has different trucks with different numbers that pull different numbered trailers. When I select say, "T & L" from list c8 I need the lists in that row E8 & G8 to display only the information related to that trucking company and no others (as opposed to every trailer number and truck number on the lists in row 100). Only T&L drives a truck with the number 08 pulling a trailer with the number 564, etc. I need the same thing to happen for the truck list E8. When a particular truck is selected the lists in g8 narrow to the numbers of the trailers that that truck have pulled in before. So e8 (truck number 88) makes g8 list trailers 8855 and 8445 because that driver only pulls those trailers.
If you can kindly help me with that macro to work for a sheets in the workbook that would help a lot. The only thing is it's useless unless the program can learn new trucking company names with their respective trailers and trucks (we get new ones sometimes). I created the "ADD" sheet to be able to add new trucks, trailers, carriers (companies) and employees. If c8 doesn't have say "t&L" trucking company in it I can go to the add tab and type into cell a4 the carrier, d4 trailer number, g4 truck number, etc. I need that information to add itself to my list on the "page 1" tab into the orange colored list a100:a200 while the trailer goes to e100 and truck c100. The above paragraphs macro would then be able to sort the data in the list when a carrier is selected.
View 9 Replies
View Related
Jan 8, 2008
Triggering a message box. one of the worksheets in my workbook is called Update Comments - this is a sheet that contains data in the following format (headers)
B7 = Week Number
C7 = W/C
D7 = Update Due
E7 = Updated By
G7 = Update Comments
I have a formula in column D (beginning D8 and copied down for the year) as follows:
=IF(AND(C8
View 9 Replies
View Related
Jan 10, 2008
I am trying to format my x-axis to list only the labels that have corresponding data points, but at the same time maintain appropriate number spacing. For example, My x-axis range is 0-90; however, I only want tick marks at 0, 5, 13, 40, 85.
View 4 Replies
View Related
Feb 8, 2009
Two questions:
1) How do make values on x-axis as words? E.g. apples, oranges, etc.
2) Is it possible to have the numbers on x-axis in descending order? If I can figure out 1), I can do this as well, but it would be nice to know if it is possible to have the numbers on x-axis in descending order.
View 8 Replies
View Related
Mar 30, 2009
i am looking to do a table which shows time started, time finished and then a total for hours that day, then that week.
Start 08:00
End 16:00
Total 8 hrs.
How can I get the total to display as 8 hrs? not 08:00? When I change the format to "number" it shows 0.33?
View 9 Replies
View Related
May 5, 2006
I have a user form with textBox1 = start time (entered as "[h]:mm") and text Box2 = finish time (entered as "[h]:mm"). I would like textBox3 to display the difference between the start time and finish time as a general number!
For example
Start time: 21:00
Finish time: 06:30
Hours worked: 9.50
Start time: 12:30
Finish time: 23:00
Hours worked: 10.50
View 9 Replies
View Related
Mar 5, 2014
What I need is a formular/vba code that can divide hours into different time ranges. The picture below shows an explanation.
In example 3 there time range analyzed goes from saturday till monday. Here Sunday should get 24 hours and the time range 23-08 for weekdays is at this point 00-08.
I've tried everything I could imagine to get this one working,
View 1 Replies
View Related
Dec 19, 2008
I have a worksheet which contains START TIME in column A, then TIME USAGE in column B and END TIME in column C. User enters start time, followed by the number of time usage in minutes, how could i possibly display the end time automatically in this scenario? how do you add the entered time usage to the start time to display the end time? Say if I enter 1:00 AM at start time and 00:15 minutes on time usage, how can 1:15 AM be displayed on the end time automatically?
View 2 Replies
View Related
Feb 20, 2009
I'm battling to come up with the formula to calculate time and a half and double time. My boss wants me to show the overtime worked AFTER 40 hours has been worked. I have attached a copy of my spreadsheet.
View 4 Replies
View Related
May 30, 2012
I want to add hours to a date-time cell to get result in date-time.
Format of cell A1 is d/m/yy h:mm AM/PM
Format of cell A2 is General
Format of cell A3 is d/m/yy h:mm AM/PM
I want to add A2 (number of hours) to A1 to give A3.
The formula I used is A3=A1+Time(A2,0,0)
The formula works perfectly fine when A2 is less than 24, but when A2 is more than 24, the date doesn't get changed.
View 6 Replies
View Related
Nov 14, 2012
I have this spreadsheet where it is basically call center data so in one of the column it shows time of inbound call as example (21:12:05) and other columns shows specific notes about that call example if product was sold on that call or not. So I am trying to find trend that during what period of time in a day maximum product was sold. Example I want to set some criteria that from 8 am to 10 am, 10 am to 1 pm and so on and then to find how many products are sold. So what I am looking is how can i extract hours as numbers only? from time stamp? I tried using =RIGHT(a1,2) but its not working and it messing with the number format.
View 4 Replies
View Related
Nov 27, 2012
Example attached : Copy of CAB.xlsx
View 2 Replies
View Related
Nov 20, 2013
EXPENSE MASTER 2013 sample color.xlsx
I have numbers that will display in column G. I have payment types entered in column E. So if 'C FUEL','FA','C M/C', is entered in column E I want the number in column G to be red.
View 3 Replies
View Related
Dec 1, 2009
I made a time sheet. In this time sheet i made a macro where when I press ctrl+t it fills in the date in a column and the time in the column next to it. So to start my day I would press ctrl+t and to end it i would goa column over and repeat the macro. and then i made it so that in the fifth column it adds the 2 times together with this formula "=IF(E27>0,(IF(G27>E27, G27-E27, 1+G27-E27)),"")" formula works fine unless you make a "mistake" and change the ending time manually to a time that is early then the starting time but on the same day. So I wanted to see if there is anyway of the total time column can return an error message if the ending time is earlier then the starting time by looking at the date in both date columns. Im going to attach the workbook to this post. on the tabs on the bottom it is under time sheet. and i think the macros should transfer over too. ctrl+t is the time macro if you want to try it out.
I may have not been so clear on explaining it so ask any questions if that is true.
View 13 Replies
View Related
Aug 5, 2014
I am measuring total time accumulated over a week using hh:mm format. Once I pass over the 24 marker then the format changes. How can I keep this to hours only?
View 3 Replies
View Related
May 13, 2014
We have a bar code scanner that scans employee IDs as they come and go each day. Beside the ID is the date/time stamp in the next column. They do not always come in in the same order they leave, so I am looking for a solution that will collect the in and out time for each ID, then add those times beside each employee name, and add them for a hourly total.
View 10 Replies
View Related
Aug 24, 2009
I am struggling to find a formula to calculate hour:minutes between the following:
Cell
A1= 04:00
B2= 17:00
I am wanting to calculate the hours between 06:00 and 16:00 and then the hours between 16:00 and 06:00 the next day
ie: 06:00-16:00 = 12;
16:00 - 0600 = 3
View 14 Replies
View Related
May 16, 2013
I want to automate the Display labels in my Charts using VBA Coding…
I would need to use this small code in Charts with different Scales as some of the Scales in my Data are in a very large Range close to Trillions so its not possible to have these as the Primary-Y-Axis Scale and therefore I would need to use the in-built Display label option which Excel provides..
However, I always prefer to have the scale in the Range of Thousands so the Max I can have in the Scale can be 10,000 so if there is any Number more than that or the Scale is going above than I would prefer that this gets auto-calculated to Multiply with the remainder and show appropriate Scaling.
For Ex:In this example My largest Number is 4500000000 which is 100 M..So I would want the scale to show 4500 and the Display label as X Millions..
So The Display Label would be different for different Ranges but the Max Scale preffered would be 10,000.
View 8 Replies
View Related
Jan 14, 2008
I have received and error message:
Excel found unreadable content in "……………". Do you want to recover contents of this workbook?
This workbook has been used for quite some time now.
There are 3 of us who use this workbook nearly every day.
It opens fine on my pc but not on the other 2 (we all run 2007)
Now when they open the workbook it comes up with the following error.
If they open an older version its ok, however if I open it, do nothing to it, save it and then close it, the error appears.
View 9 Replies
View Related
Jul 5, 2009
I am using office excel 2007 with all the latest updates installed on a windows vista machine. 3 months ago i made an xlsx file containing contact information. Few days ago, it was consist of 4 sheets. 1st sheet had about 18000 rows and 1 column while the other 3 sheets have about 100 rows and 1 column each. The last 2 days i get an error when i try to open the file i get the error Excel found unreadable content in "name.xlsx" Do you want to recover the contents of this workbook? If you truth the source of this workbook, click Yes. If i click on Yes i get another error this file cannot be open by using microsoft excel and ask me to search online. If i click no, 4 times, as many as the sheets i get the file open. with the following message
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Replaced Part: /xl/worksheets/sheet1.xml part with XML error. The name in the end tag of the element must match the element type in the start tag. Line 2, column 1249206.
and the 1st sheet with the most records is empty while the other 3 sheets are ok. I tried the built in repait method no go. I unistalled and reinstall office without installing the updates, nothing. I also tried some recover programes where only the recovery toolbox for excel worked but i am searching for a solution that i will not have to pay more money beside the office product to recover the damaged office excel.
View 9 Replies
View Related
