colon

  1. P

    INDEX range and INDIRECT not working inside LET functions

    Hello, I'm calculating Split Multiplier column from Split Ratio column by multiplying the rows from the current row towards the end of the column. It works nicely within normal excel table with PRODUCT($B3:INDEX(B:B; ROWS($B$3#)+ROW($B$3)-1) ) where the formula is copied down, but if I try to...
  2. D

    Building a better mousetrap.

    Hey guys, I'm brand new here, and I just joined a few minutes ago. I work at a prison work release and we have to sign prisoners in and out of the facility, and sometimes it gets pretty overwhelming. When you work 12 hour graveyard shifts, it's kind of hard to convert, calculate and subtract...
  3. A

    Delete everything before the colon

    Hi, Please give the macro code to delete everything before the Colon (:) in column B. Thank you in advance.
  4. masud8956

    Limiting cells to be filled out by specific characters

    Hi all! I have a range of cells, say A1:F30 where I want the users to be able to enter the characters 0 to 9 a colon [:] only. The cells are formatted as [h]:mm and the colon will always appear in between the numeric values e.g. 1:15, 2:45, 10:05 etc I tried Data Validation with the following...
  5. U

    VBA: Concatenate data with and without colon from respective rows in B and C cell in all excel sheet

    VBA: Concatenate data with and without colon from respective rows in B and C cell in all excel sheet From D data can be in any cell with and without colon symbol. The empty cells can be anywhere. Example mock data is below: Excel 2010 <colgroup><col style="width...
  6. B

    Insert Semi Colon

    Good evening all I am adding a semi colon in string of 3 after the 1st number & a semi colon in string of 4 after the 2nd number utilizing the below code. The issue I am having is at the end of the range when additional values are entered the cell returns 0:00. when the code is run again the...
  7. N

    VBA Code to delete information following a character

    I have a report where every cell in column "F" has an expense description separated by multiple colon ":" symbols. I cannot seem to write a macro that will find the last colon in the cell and eliminate everything following it, including the last colon as well. I would like the program to do...
  8. masud8956

    Inserting duration in a column without using colon and adding them up

    I have a column with 56 rows. I want to insert duration in [h]:mm format without having to type colon. For that I formatted input cells using 0\:00 to get a return at row 57. The problem is, while adding up those duration I am getting erroneous results. e.g. 0:30 and 0:40 are added up as 0:70...
  9. A

    Regular Expresions

    I'm trying to understand this pattern RE.Pattern = "^[A-Z|b]?\d+\. .*:[0-5]\d$" Is the following correct and could you tell me what \. . means ? ^ Start [A-Z|b] Any char "A-Z" or "b" ? all before zero Or one times \d+ Matches a single digit one or more \. . ???? *:[0-5]...
  10. D

    Hours:Minutes Only in Cell

    I have cells formatted to [m]:ss, which I thought would do the trick, and for the most part, it does. The only issue I'm having with this format, is that the user is required to type the number 0 and then a colon in order for result that I want. For example, if the user wants to log 37 minutes...
  11. B

    Help - Excel Spreadsheet Split into Separate Sheets with File Name Preceded by a Colon

    Hi - I opened up my spreadsheet (call it "ABC") in Excel and the file opens up as several spreadsheets with a different file names ABC:1, ABC:2, etc I can't figure out what the heck is happening to cause this. Thanks, Brian
  12. Norm Shea

    Formatting a number string to "time"

    I have a mapping program that uploads data with the date and time but when it exports it the time is converted to just a number string, e.g. 15:12:37 becomes 151237000. Is there way to eliminate the last three zeros and insert a ":" between the second and third, and fourth and fifth characters?

Watch MrExcel Video

This Week's Hot Topics

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
Top