times

I amtrying to get the value of the difference between two times with the code below. tdiff = ((CDate(Me.uf9a_tb_cend.Value)) - (CDate(Me.uf9a_tb_cstart.Value))) - 0.5 .Cells(drow, 5) = Format(tdiff * 24, "0.0") Me.uf9a_tb_cend.Value = "3:00 pm"...

Sorry for the long post, any help is appreciated. I am working on the Macro below. I am hoping someone can provide a little guidance on a few questions. 1. Should the Marco be in Module1, The spreadsheet I am running it against or in ThisWorkbook? 2. I can run the solver without an issue...

i have a list of files with dates associated. i'd like to simply count the number of times each date is being shown. for example, 1/2/18 is shown below 10 times. I have this for an entire calendar year. <colgroup><col></colgroup><tbody> 1/2/18 1/2/18 1/2/18 1/2/18 1/2/18 1/2/18...

I have a table I am working with that has project names that are listed multiple times (along with a bunch of other data that should not be relevant here). This is in Power Query What I want to do is a running total of how many times the project name appears then start the count over when a new...

Hi We've had a weird problem where excel seems to create hundreds of random named ranges in files which have NO named ranges. It's only happened three times and all of those times it happened on files which were linked to other files but it also doesn't always happen so I am not sure what's...

This post is somewhat similar to a previous post which I have not gotten a response yet. Since then I have figured out answers to my questions with the exception of this one. If I am wrong for doing this please let me know. Thank You Brief explanation:That being said, I have a workbook that when...

Consider time interval: 08:00AM to 09:30AM which is to the constant time interval against which a dynamic list of other time intervals such as: 06:00AM to 07:30AM, 7:30AM to 09:00AM, 09:00AM to 10:30AM, 10:30AM to 12:00PM, and 07:30AM to 10:30AM; are to be checked against to see if any of the...

I have a workbook that will automatically open, save and close 2 times a day to keep it updated. Its also looked at by several people so I was wondering if a Macro could make a copy each time it opens and closes? I would like the entire workbook to save to the same directory but a different...

Good evening, I have spreadsheets that I receive from clients which have times in different cells. I have a 8:50 in cell A1 and 3:10 in cell B1 when I looked closer the cell values both have AM in them. I looked at the next one and it also has 7:15 and 4:10 and they are also AM. The times will...

Hello, I have the following COUNTIF that works well, but recently realized it's not useful given there are duplicates, thus throwing off my numbers. =COUNTIF($A$1:$X$145, "*"&A213&"*") I have a table of text spanning from A1 through X145 of server names. Given the server, the exact name could...

Hi all, I am trying to evaluate if a column on another sheet in the workbook’s date is less than 6 months ago and count them all up when the value (in this case it’s a person’s name) in one of the columns = the value I am looking for. I then what to split out the percentage of how often it was...

Hey Everyone! We are working in Excel 2016. When we typed a VLOOKUP into a cell, it turned into a truncated picture. We could type behind it, and type a new formula below it, and could not move the "picture". This file has been used many times and was a one time occurrence. Has this happened...

Hi All, I am trying to put in a formula as above. Numbers between 80 and 170 are in Cells A2:A147. I want to look at Cells A2:A147 and count the number of times a figure of between 100 and 149 occurs. Thanks for any help

Hi All I have 2 sheets with almost 300k rows of data.. The columns are from A to Q the dates, agent name and start times and times are sorted to sort each agent schedule that day I need to have a macro that loops through every day and checks to see if an agent had any activity that say...

Hi All we are wanting to calculate the lifetime value of a customer. I have history table of 3 columns (10k of entries) with the customer name appearing every time they have ordered over the past two years. Is there a way I can count the number of times a name appears in a list. Ideally...

Hello All, I appologize in advance that I am COMPLETELY NEW to VBA - with no real knowledge. I just finished creating a spreadsheet (sheet name is "Production Sheet") that i am in the process of creating a userform for. I had everything formatted as I liked, but came across an issue when the...

Need a hand please. I'm not great with formulas in Excel.. Searched the forum with no luck with the help I need. Below describes what I need to create a check digit. Looking for a formula to do this in Excel. Thanks for looking and help. The calculation is as follows...

Hello, I'm building a macro that identifies time errors to be fixed off a report that includes employee clock in/clock out times. The only values that matter are the actual clock out times vs. system clock out times. Specifically, if an employee physically clocked out at one time, but the...

I have a list of parts all listed down a row (A). Then I have a date column that shows the last time I purchased that part. The parts are listed multiple times in the list and the last purchase date isn't going to be towards the top of the list. I cant sort the data for various reasons. Is...

=IF(OR(ISBLANK(P2),ISBLANK(O2)),"",P2-O2) is the current formula I am using to subtract times and leave the cell blank if target cells are blank. This works perfectly 99% of the time, the issue I am running into is when a call runs through midnight. I need to be able to add (P2>O2). Ex...