1. A

    working with hh:mm:ss formats and IF statements

    Hello I am trying to write an IF statement using date/time/hh:mm:ss data and would appreciate some help. I have ~ 150,000 rows of data so am keen not to review line by line. I have an extract of data with a date time stamp and I have calculated the difference between two times. eg: I have...
  2. A

    Insert a line break after word wrap

    I have a multi-line textbox I want to insert a line break after word-wraps to a new line. Can someone help with a vba code that can do this. Thank you kindly
  3. N

    Cannot delete page break in Excel

    I have a page break that is making the first page very small, I have tried everything to delete it and nothing works. Heeeellllpppp!!!
  4. A

    break even analysis

    hello everybody. Happy almost Friday. (I'm an optimist!) has anybody out there done any simplified profitability/break even analysis for an earthmoving business or for a wet hire type operation with similar drivers to earthmoving? I'm helping out a friend and I want to capture as much of their...
  5. N

    Aligning value and associated fields to match another column, with new rows created if needed.

    Good afternoon, In the spreadsheet, which was populated by tableau, the quantity break and its associated price from the last record and those from the previous record do not line up. Is there anyway we can match values in column P, along with the prices in column O to values in column N? If...
  6. T

    Removing entries into a list from a worksheet

    Hi, I have been trying to find a solution for this, searched everywhere, but cant find anything. I have a sheet with multiple colums of names. I have another sheet in the same workbook where a user enters a name/names into specified cells. Is there a way to automatically remove all the...
  7. N

    Time conversion help

    Hi, Hoping Toadstool will see this as he knows the history of what I have been trying to do. But if anyone can help I would be so grateful. I am doing timesheets and have formulas in now that work for adding hours over multiple rows and then multiplying it by 1.5 and 2. What I need now is...
  8. P

    Working hrs. Minus breaktime (8hrs/day) from range of days

    Work Start: 8:00 am Work End :5:00 pm Break Start: 12:00 pm Break End:1:00pm I am trying to compute the working hours with raw data like 08/30/2019 4:00pm - 09/02/2019 9:00am. The result in this one should be 2 hrs only. But if the raw data is 09/02/2019 8:00 am - 09/02/2019 9:00am result...
  9. L

    so close yet quite can't get in

    Hello! I feel like I am sooo close to figuring out this formula or conditional formatting but just can't quite get there. Its simple... per a collective agreement, any of employees that take their breaks "late" or don't take them at all are entitled to pay at 1.5x for that break. I get an...
  10. I

    Pivot, Vlookup, Index and Match, Powerpivot? What is the best method???

    Hello, Looking for some advise on the the best method for accomplishing this task. I'm working on a project that involves pricing. We want to be able to analyze some pricing, but to do so, I need to transpose multiple lines of data into one line. Here is an example of the data. Customer -...
  11. N


    Hi, I am working with a spreadsheet that was pulled from an external data source. It imported the time column as text (example: 07:30m or 12:00am). No space between. I've gotten it to work if I break it into 2 separate columns using the following 2 formulas: =TIMEVALUE(SUBSTITUTE(D2,"pm"," pm"))...
  12. R

    Inserting rows

    Hi All I want to insert a row or rows and keep the page break the same. So if the page break is under row 40 and I insert lines, the page break remains under row 40. Is it possible? Thank you!
  13. F

    Break Revenue Down By Month - Start End Date and Amount

    Hello, I have two dates and an amount field, I want to break the revenue into each month. I have a formula =(IF(AND($B2>=D$1,$A2<=DATE(YEAR(D$1),MONTH(D$1)+1,0)),MIN($B2,DATE(YEAR(D$1),MONTH(D$1)+1,1))-MAX($A2,D$1),0)/($B2-$A2))*$C2 It breaks down the revenue incorrectly across the months. I...
  14. O

    VBA Code to Break a Comment into Multiple Lines

    Thanks in advance for any solutions, suggestions or help for which I will give feedback. I have two questions which are similar, but not exactly the same: (1) How do you break a comment such as the following into multiple lines (i.e. continuation)? This is basically so I can keep it on the...
  15. L

    Total Time Less Lunch Overlap

    Hello is there a way to adjust the formulas in Column I so that if the times overlap the lunch break (12 pm to 12:30 pm) it deducts that time? I have the Lunch In L12 and Lunch Out L13 if that matters. So it should be a 30 minute break. The result of the new formula would then be I5 2.5...
  16. P

    Append Query to Table Issues

    Hello, I have 5 Fields that append to a table. All can repeat but I only want one unique record of each type. When I do the append, it just keeps adding duplicates because I can't set a primary key. Any ideas? Fields: Order Operation ID Description Complete Bear in mind...
  17. A

    Formulas with staff rota

    Good evening all, I am trying to create a simple weekly rota for my team that will add up the amount of hours worked each day minus their breaks and also to add up their total hours for the week. Can anyone help me with the formulas please? <tbody> SUN MON HOURS MINUS BREAK TUES HOURS MINUS...
  18. V

    VBA Excel code doesn't run completely

    I have a macro but when i run, i only run to specific line code (of course i don't use break point mode or F9) Eg: Line 1: ..... " code here " Line 20: ... " code here " Line End:... It only runs to Line 20 and stop there, i have to press F5 if i want to continue. That is like break point mode...
  19. T

    Pivot table, display weeks

    Hi, I have created a pivot table that is displaying expenditure by year, quarter and finally month. Is there any way I can get it also diplay break done for each week in a month?
  20. K

    Link wont break

    Hello I have a workbook with a link to and old file, i have tried to break the link, open source, change link, get rid of any conditional formatting, delete irrelevant work sheets, data validation etc, but i still cannot break this link! Does anyone know anything else i can try? Thanks

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...