1. L

    convert time to fractions 1/24/ 2/24 etc

    Hi I want to convert time to general (number). I want the numbers to be appeared like this 1/24, 2/24, 3/24,...., 24/24 I changed times to fractions format but I did not get what I want. In some cases like 10:00 pm, the fraction format changed it to 1 instead of 22/24. Thank you very much...
  2. R

    keyboard Shortcut for the ½ character

    Hi I have some tedious data entry to do into a spreadsheet. Mostly text. Every once in a while I have to use the 1/2 character in a string So I can copy and paste the character from the clipboard (very quick) but copy/paste gets used a lot anyway so then I have - to stop typing. go find the...
  3. M

    Help with nested IF statement

    Employee A , aged 62 is in a pension plan, the rules of which in 2015 were: Payout = 1/2 of Salary or 15000 whichever is less, in 2019, the rules changed payout = 1/2 of Salary or Social Security limit whichever is less but if Employee A is above the age of 62, the rule has always been payout =...
  4. K

    Nested IF In Excel

    I Have a spreadsheet that contains Data and I have a second tab and on the second tab I want if Column T4:T58 equals Yes and if Column U4:U58 equals Test1, then populate column into the cell and I can't seem to get the logic correct. Column B4:B58, has Customer Name, Column Q4:Q58 has Date...
  5. L

    Project Management Database Help

    Hi All, I'm working on a tool that will help me manage project planning for my team. I have a basic sheet that looks something like this: <tbody> Task Time Allowed (in hours) Assigned to Start Date End Date # of Days 1/1 1/2 1/3 1/4 1/5 A 2 John 1/1 1/2 2 1 1 0 0 0 B 5 Sally 1/2 1/5 4 0...
  6. N

    Sumifs + vlookup

    I'm trying to do something I am sure has been done before. I can't get it to work the way I want though. I have two criteria that need to be used (depth and edge letter) to look up the correct dimension. I've tried VLOOKUP, which does fine if I only want to look up one criteria. I'm not sure...
  7. G

    Find the Largest number based on date and trade

    I am trying to find the largest number based on the date, then quantity on trade for each day of the month. I currently do it manually each day but am looking for a formula to do it for me without using the ctrl+shift+enter function. Looking for the formula in largest trade column <tbody> Date...
  8. H

    Date Range Formula

    Hello, I am new to the forum and looking for some opportunities to enhance some sheets in excel. I am looking for a way to translate several date ranges to a list of dates in Excel. Example from Sheet1: Cell A1: 12/24 Cell A2: 12/28 Cell B1: 1/2 Cell B2: 1/18 Cell C1: 1/25...
  9. J

    Showing a fraction in the "normal " form

    I've only just found out in Microsoft Word how to type a fraction in the "normal" way, that is with the digits one above the other - if .5 is wanted as a fraction, type 1 followed by / followed by 2. Then press the space bar. The 1/2 changes to 1 over 2.(can't show it here!) I have been looking...
  10. S

    Combine CSV Files

    Hello All, I have been using command prompt copy *.csv combined.csv However it has started failing for me on 1/2 the files. (trying to combine 365 files) Does anyone know another way to combine multiple .csv files quickly Regards, Simon
  11. J

    Sorting, Adding cost values for each input, Deleting row & writing a total

    I have 7 columns that contain data. In column A, there can be identical descriptions for each input. In column K, there is a total cost for that row entry. In column N, I have quantities (if applicable) for each entry. I have the sort vba code figured out as such... Sub UnMerge4Sort()...
  12. J

    Sorting by size

    Hi all! I would like to sort by size but its size x size like the fallowing ( I already tried creating a custom sort list but that has a max 255 characters) Any ideas how this can be done? 1/4" 1/4" x 3/8" 1/4" x 3/4" 1/4" x 1" 1/4" x 1-1/4" 1/4" x 1-1/2" 1/4" x 2" 5/16" 5/16" x 1-1/4" 3/8"...
  13. N

    Reading through the spaces

    I have a CSV that is received from another department that I pull into my workbook. One cell contains fractions and the inch mark followed by 17-24 spaces. I'm trying to pull from that cell to indicate what file I need to look in for the information and I'm not sure how the pull the...
  14. K

    Need a scraping tool of blackwoods

    Hi all, I have certain number of part number of blackwoods. can anyone help me build a VBA tool to scrape some information from the website using those part numbers. Ex: Part Number: 01861905 When you search it in blackwoods website you will find below link...
  15. K

    Best way to extract a range and list the first value by itself and then list it again with a range

    I have the following data: Coluimn A Column B 15CJ1R1 - 6.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE 15CJ1R1 - 8.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE 15CJ1R1 - 10.00 Sch 160 , ASTM SA335-P11 (1 1/4 CR; 1/2 MO) , SMLS , BE 15CJ1R1 -...
  16. S

    Aggregate Bill Of Material

    Hi, I have a program that generates a cut list of materials depending on size and type of unit. Now the guys just take the files and manually aggregate it. I would like to do this programatically. I want to sum the quantity where the width, length, thick, and Matl. match. Red totals 20 parts...

Some videos you may like

This Week's Hot Topics