times

Hi all, I've found a VBA script to duplicate the current active worksheet, but I need to copy a different worksheet in the workbook X amount of times (X = number in a cell). e.g. Active Worksheet Name: Start Worksheet to be copied: Master Copied X times where X = Start!A10 Names of...

I have a sheet that contains start times in column A and end times in column B. I have another sheet that I would like to pull the start time and end time into one cell for ease of printing. Like this - 8:00AM - 5:00PM When I use the following formula - =sheet1!A1&" - "&sheet1!B1 it pulls...

Excel Experts, I have a customer who has given me a spreadsheet of about 1,300 words they consider profane. They will be sending me a mailing list of names they want to send samples to. However, they do not want to send a sample to any customer name that contains one of the words they...

RE: Displaying a userform reminder to appear on future days and times from current userform values of date and time... I don't know if this has been fully developed before but I need just a little guidance in the heart of the reminder I'm developing. I’ve already developed code for a userform...

I have start times listed in column A and corresponding stop times in column B I need a macro to calculate all the elapsed time and create a new stop time adding all of the elapsed time together. So if: A1 = 12:00 PM B1 = 1:15 PM A2 = 1:30 PM B2 = 2:15 PM A3 = 10:00 PM B3 = 1:30 AM Total...

I have 2 sets of data. One contains ID# and dates . The other set contains same ID # and different dates. Each ID # occurs multiple times, but not equal number of times, in each spreadsheet. I want a formula to look for ID # match in the second spreadsheet and return the date that is...

I've got a question in regards to a formula that I'm having trouble solving. Is there a way to find the times with the shortest time between them and then be able to calculate the time inbetween said times. I would normally not have trouble doing this (when the times are in different cells)...

I am trying to figure out how to remove all data [including opening parenthesis "("] which is appearing after the last occurrence of opening parenthesis "(" in a given string. Refer below example: <tbody> <colgroup><col><col></colgroup><tbody> RAW DATA OUTPUT ABC (P) (L) (30365) ABC (P)...

I have seen a number of similar threads on this subject, however I have a variation. I have a sheet with 211 rows, each row needs to be copied and inserted multiple times. The number of times it needs to be copied is in a cell within each row (Col G). So The first row has the number 14 in Col...

Is there a formula that can be ran on these values to then return something similar to the sample table provided below. The objective of this formula wold be to break down minute by minute is there are 0,1,2, or more times overlapping. <colgroup><col width="80"...

Hi, I tried different steps two subtract two times (cell b-cell a) using calucated fieldd and output the total in cell c but my output is totally wrong. Could someone look into this for me. Much appreciated. Shall I upload sample file? Thank you

Hey, looking for some help with a code that will copy a range of data and paste x numbers of times depending on what value is selected. In addition I would need column A (starting in A8) reference how many times the data set was copied. Thanks in Advance Drop Down Box: B1 Range of Data...

Hi, I feel there should be a way to automate this, I'm just not seeing it. I have a list of participants, each have chosen 5 out of 8 possible classes. Classes are offered multiple times over 2 days, 4 classes at a time. I have the class times and schedule. My goal is to assign 'students' to...

I am doing lottery odds on excel for fun. So I am doing a 5 column lottery. I am trying to figure out in Column I (Labeled 4th Ball) How to highlight the numbers that show up in a row the most frequently and to highlight them a certain color. For example, rows 20-22 all have the number 15 so...

Hi. Please see link to the relevant file, below: https://1drv.ms/x/s!AtIvkRgReIvwgRPV4fmLEL1-gjz- I have a problem that I can’t seem to solve. I have this list of times and positions, with the times in hh:mm:ss format. However, the times have the minutes and and seconds in the wrong...

Hi everyone, Have a request for a formula. In cell A10 I have a value of 1 Cell A15 I would have the formula that would do the following: I know the value 1 is in cell A20. I want to count how many times the value 1 repeated below cell A20 before the value changed. So in the example below...

Hello there, I use countif formula to find out how many times in one year 8 numbers have matched. Usually 8 numbers match only once a year or maybe not. prize money for 8 numbers is 10k as above. But there many times 4,5 or 6 numbers match. For example to find out how many times 4numbers...

In column A, I have strategically placed the value of x in specific rows. I use a macro that goes to column A and then executes selection.end(xldown).Select a certain number of times depending on which row I want it to land on. For example if I want it to select the third row with an x I use...

<tbody> A B Formula in N Result of formula 05/28/2019 05:15 05/28/2019 05:00 =IF(A3="","",TEXT(TIMEVALUE(TEXT(A3,"HH:mm"))-TIMEVALUE(TEXT(B3,"HH:mm")),"hh:mm")) 00:15 </tbody> This has to be simple, and don't know why I'm unable to think of how to do this, but I need some help...

Hi All, Working on a spreadsheet and wanting to know if anyone can assist me with a formula to highlight fields based on inputted times. I currently have rows H - Y with times at 1 hour intervals. 0600 0700 0800 etc I would like rows F to be the start time and row G to be the finish time...