colon

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

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

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

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

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

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

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

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

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

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

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

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?