I will use it to display a text-box reminder of important appointments at a set time, but I have no idea how to proceed. It would be a most useful application to have, as my memory isn't brilliant. Any help would be great. I need an IF Function that will allow me to action a time in a time range:... If the time 04:16 falls in the time range 04:00 - 04:29, than put a one 1 in the filed x... If the time 04:16 doesn't fall in the time range 04:00 - 04:29, than leave the x fiel empty Any help is appreciated. I was wondering if anyone could help me out please?!?! I need to have a cell on Sheet2 display the TEXT from a cell on Sheet1, is his possible?? Example: Sheet1, Cell A1 contains a clients name and I would like to have Sheet2, Sheet3, Sheet4 etc... Display that clients name in a cell of my choosing could be a different cell on each Sheet automatically after entering it once on Sheet1, cell A1. I thought this was possible but I can't seem to figure it out. I haven't done any real Excel work in quite a long time but I thought I had done this before a long time ago!! Any help would be GREATLY appreciated!! If I use autosum to do this it just displays the number 0, obviously, since it is trying to add numbers... I uploaded a copy of the spreadsheet, What I would like to happen is have the text from Sheet1,D4 automatically be placed in Sheet2,A1 and Sheet3, B2. Hope this helps -Aric Hi all, I have a dillemma here, I have to create a schedule which incorporates lunches automatically either half hour or 1-hour lunches, depending on the circumstances. If someone can help it would be greatlyyyy appreciated Good afternoon, Is there a way to enter a colon into a standard number to create a value that can be formatted into a 24 hour time value? Other than creating a table and using a vlookup function, I am hoping there is a better way? Darren I am looking for assistance in having one cell in a text format equals another cell that contains a time value in hh:mm format. For example: Cell A1 has a time format hh:mm value of 04:00; which is the Start Time. I would duplicate the same formulas to reflect Stop Times in other cells. The times would change based on the Time formated values entered into the Start and Stop time cells. I have researched this in the board and found many excellent ways to do the opposite, but not convert Time format to Text format. Any assistance is greatly appreciated. I want to be able to just highlight the selected range of cells I need to insert into and hit a macro button and have the date and time inserted into just the cells I have highlighted. I'm not sure how to make this work with just the cells I've highlighted. Any help any one can give me would be greatly appreciated. Mike I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a. I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good. But I have to save as a. So if I do that, close the Excel window, and then open again as the. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as. Does anyone have any idea of how to work around this? Thanks so much for your help! End of office hours 6:00 pm, strickly no over time I have never really used VBA and so am completely stuck at this problem. I need to create a macro which auto-populates a master worksheet from the individual user sheets in a shared workbook. There will be an undetermined number of individual worksheets to accomodate new staff. Each worksheet will be identical, using columns A-I with row 1 having the headings: Date, Name, Reference, Value, Price, Age, Purchased? Products the last 3 columns will have a drop-down list which will be used to enter data into the cell. There will be a varying number of rows in each of the individual sheets. If possible I would like the macro to run every time data is entered into one of the individual worksheets. If this is not then it would be fien to update every time the workbook is opened. If anyone can help it would really cut down the time I spend collating these stats every day! Hi, I made a simple worksheet that we have been manually entering the time for employees, but there are too many errors even with simple math. Can someone help me convert the time of ex: written 8-4:30 or 10-3 meaning 8:00am to 4:30pm where you have the total weekly hours? Right now I have a column for overtime. Is there a way to automatically calculate the over time also? The work day is 8-4:30 with a half hour lunch lunch is not calculated into the hours, so you minus a half hour. So, if a person works 8am to 6:30pm, how can I set it up where in the first row of time, I will type in 8-6:30pm. In the totals column to the far right, it will display 8 hours. Marty Hi All, I've been struggling with this for a while now and can't believe how hard it is!. I've searched on this site and on others to get some clarification but to no avail. It's pretty simple really. Please can someone give me a bit of guidence or link me to a good rescource if missed it in the search. G How do I calculate the number of batches per hour? Is this the correct way to solve the problem? Hi there I am trying to calculate our On Time Delivery. I want this as a simple percentage of jobs. My problem is, if we enter a date in Estimated without a corresponding Actual date, the formula for Column O fills out anyway and improves our On Time Delivery Percentage. How can I set this up so that the formula doesn't calculate if there is no data in Column N? Any help much appreciated Thanks, James Hello, Firstly i haven't used excel to a great extent since my college days. So i'm having to re-learn 99. I am volunteering for a non profit organization and trying to create a reservation system for the rooms that they have - kind of like hotel software, but in excel i did a similiar thing in college but for plane seats Please find it attached. What i need it to do: Copy all of the info from the main page to the guest lit a new row each time. From the guest list to the Gannt chart - i did a few tutorials on dynamic gantt charts using conditional formatting but cannot get them to work when based on data on a different worksheet. Finaly is there a way to check for availabilty on any given date? Best Regards, Jamie P. I am working production scheduling with Start and End time but there is a lunch time and tea time. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. Duration Process :6 hours. Start Time 8:00am End time 5:00 pm I need a formula to calculate from Start Time 8:00am and what is the End Time? Thanks, ET Hello everyone. This is marc, i have one doubt in my mind. Thank you in advance,... Marc I need a formula to calculate Turn Around Time. Find below the sample data and details for your reference. Please let me know if you need any more details Hello, Please help!!! They work on shifts and the operation is 24 hours. Each gets 30 minutes for breaks which is not paid. Pay is biweekly and overtime is anything over 40 hours. I am in desperate need for help. On the attached timesheet there are columns IN, OUT, IN,OUT The lunch time is worked out by deducting 'C8 from C9' and this works fine when all 'IN, OUT' cells are filled in but for some reason when just the first two cells are filled in it gives a -12 hour answer.
