1/2

  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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top