timestamp

Hello- So I have three Macros that create sheets- Macro 1 creates "Noon" or Sheet1. Macro 2 creates "Noon#" which is essentially a copy of "Noon" and whatever number and can be near infinite. Macro 3 creates "Arrival" which is the summation of the info from all of the noons. Anyway, I wrote a...

Hi all, I have found this code for a timestamp, which I have pasted in VBA under the applicable worksheet (which I believe is the correct spot?). Column C has an IF formula that returns a TRUE or FALSE. The answer always starts out FALSE. The code is supposed to look for changes to cells in...

I am trying to find a formula that will enable to count the number of unique days in a list. I have a table with one column showing the date with a timestamp. I wanted to count the number of days in this column. Dates with the different timestamp will still be counted as the same day. For...

:banghead: I'm trying to do a Timestamp that won't change every time you reopen the workbook :banghead: . In this linked workbook I have "Meeting Date" in column B. Column E is where I want the Timestamp. So, I can get the timestamp to display the date (I added the hh:mm:ss to test), every...

Hey guys, So recently I used a thread I saw on here to create a code that will input a time and date whenever a cell value changes. I used it for one range (the first part of my code that I will post), but then when I added the second part it worked once and then stopped working all together. I...

Hi! Background: I work with customer service and want to register how long they have to wait before they get their products. I receive a receipt from each customer and then we are multiple people at once picking their orders. How I have done thus far: I use the "Forms" function to add...

<tbody> A B C 1 DATA current timestamp ? 2 3 4 </tbody> Kindly help to auto insert current timestamp in Cell B1 when cell A1 is modified. worksheet is shared with 4 users and all users enter data on it.

Hello all, First time posting, I'm having trouble with a simple VBA sub I've been working on. The idea is that the code drops a timestamp into a specific cell when the Plan-Do-Check-Accept (PDCA) status of that row changes. Sub Worksheet_Change(ByVal Target As Range) Dim D As Range: Set D =...

Hello all I am using the below formula to return today's date: =IF(B2<>"",IF(AF2="", NOW(),AF2),"") I have also enabled iterative calculation so that it acts as a timestamp however the formula keeps returning the date 00/01/1900. Does anyone know why this may be? Thanks

Hi! I want to track changes I have made on my worksheet by having a time stamp against each row. I have data from columns C to AX. I would like to have a timestamp in Column AY (only date would also work), if any value changes in any cell between C and AX. I found a couple of VBA codes which...

I am trying to enter a timestamp in column B when data is entered in column A. If column B changes, I’d like the timestamp to change. I have the following code, but it is not working (I am new to this…). Sub Timestamp() If Target.Column = 1 And Target.Offset(0, 1).Value = "" Then...

Hello everyone! I'm currently working on a Macro-enabled Timesheet for my job where the employees can click a button to record the time they come in to work and leave. I have 4 fields that require a timestamp per day (Clock in for the day, clock out for lunch, clock in from lunch, and clock...

So I'm trying to do 2 things, I'm scanning serial numbers into Excel and taking inventory. Cell A1 would be the serial number B1 is the date and C1 the time that would automatically populate on every scan. After Scan is done have the cursor automatically move to the next row (A2) waiting for the...

Hello all, this is my first post here. I have tried finding an answer to my particular problem and haven't been able to. This is a snippet of the data query I am trying to write: SELECT Source.Item1 Source.Submitted_date Source.From_ID FROM Database.Source WHERE...

hi, I am new to this group. I need to sort out my timestamp which is in human-readable format. The issue which needs to be sorted is following 1. firstly, I need to make this time format in DD:MM:YYYY hh:mm:ss 2.as you can see it has similar timestamp few of them, based on the total number of...

I receive a report which details the time a truckload of material was dumped as a timestamp. I am wanting to write a formula which interrogates the timestamp and can then identify which work crew was on shift at the time the load was dumped. Shift details are as follows: 4 crews: A, B, C, D...

Hi, I am new to using VBA and have created the following by grabbing bits and pieces from the internet to make this work. Basically, I have a status column (G) with drop downs, and when I drop down and select certain values, columns are automatically updated with todays date. However, I would...

Basically I have several spreadsheets with list of guests that will be attending a event. <tbody> IDENTIFICATION NO. NAME ATTENDING? REGISTERED? TIMESTAMP <colgroup><col></colgroup><tbody> A1234567B </tbody> <colgroup><col></colgroup><tbody> JOHN SMITH </tbody> YES...

Hi Folks Currently i have a timestamps column in this format.... 2/10/2018 10:43 AM... Now i want to add random seconds in this existing timestamp column like 2/10/2018 10:43:04 AM, 2/10/2018 10:43:09 AM, 2/10/2018 10:43:18 AM, 2/10/2018 10:43:28 AM and so on like this.... Please suggest me...

I have a large number of workbooks all created from the same template file. They are all formatted in an identical manner, and each worksheet has a timestamp in cell A4 that I'm interested in extracting. I'm trying to consolidate the filename and timestamp (cell ref A4) from each worksheet...