datetime

I have a column that contains lists of dates. How do I remove dates from those lists where value does not = x?

Having trouble isolating the time component from some .csv data I'm importing. The datetime comes in as dd-mmm-yyyy hh:mm:ss:000 format, I ran a replace to repair the colon separator between seconds and milliseconds. Now I just want the hh:mm:ss.000 component. I tried to simply reformat with a...

I'm trying to determine the minimum, maximum, and average blood pressure readings from data exported from a blood pressure machine. The data includes a datetime value, and I would like to calculate different average, max and min values for morning and evening readings. I would like to use a...

Hello Excel Gurus! How can I format an Excel TimeDate from a double to mm/dd/yyyy hh:mm:ss.000 Thank you! Please call this sub to demonstrate my question: Public Sub TimeWithMS() Dim Timestamp As Variant Timestamp = Evaluate("Now()") Debug.Print Tab(0); "Timestamp:"; Tab(15); Timestamp...

Hi, Is it possible to use COUNTIF function to Range with data in DateTime format and Criteria with data in Date format to compare Dates only? For example: Range: Cells from A1 to A3: 2019-06-04 18:33 2019-06-05 09:58 2019-06-05 12:33 Criteria in cell C1: 2019-06-05 The expected formula...

Hi all, I am trying to write a macro that checks if a timestamp from an event falls between a series of two other time stamps. There is a timestamp in cell B2 and if it falls between the timestamps in G2 & H2, or G3 & H3, or G4 & H4 etc... I would like A2 to display "ERROR" The macro can stop...

Hi all, I have a table column with date values that are imported from another workbook. The original source of the dates is a database system which time-stamps entries, so each item has a time value as well. Ultimately, I need to extract a count from this table capturing the number of items...

Morning, I have posted this before but not been to clear as I'm not sure how to attach an example spreadsheet. I have tried to simplify the problem. <tbody> Day 00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00...

Good day, I have the following issue: Table 1: Column A: dateTime Column B: Item ID Table 2: (another worksheet) Column D: dateTime 2 Column E: Item ID Column F: User ID I have to find the User ID for the related Item ID and dateTime 1 in Table 1 with the following criteria: 1. item ID from...

Hi and thanks in advance I know How to put: Application.Calculation = xlCalculationAutomatic Application.screenUpdating = true Calculate Range("A1").Activate Range("B10").Select ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollRow = 100 Sheet(2).Select Sheet(1).activate I...

Hi All, I need some help with an IF formula in identifying if DateTime A is after 12:00pm the day prior to DateTime B then 1,0. For example, if DateTime A is 8/17 12:01 and DateTime B is 8/18 23:00, the formula will flag DateTime A as 1 and if not true then 0. My data source is dynamic and is...

Hi, in my spreadsheet I am subtracting a lesser datetime from a greater datetime in order to get an elapsed time (E7-E5) across several columns. These values (example: 07:20/2017 15:57 - 07:20/2017 10:49 = value 0.213888889) are then added (=sum(E10+F10+J10 etc), the result in this case is 0.22...

I am currently using a calculation from an older post to calculate end date time using a start date time and a duration. This formula excludes weekends and accounts for a 18hr production day...

Hi I'm trying to link a spreadsheet to an access database using Microsoft query, and I want it to pull back records based on the date - I know that usually to get a specific date from Access, you enclose it with #, so #10/02/2016# The problem is, I want to use the wildcard ? and link the...