timestamp

very very new to VBA but i have a spreadsheet that has entries by several people as a log. i have tried the below code but every time the sheet was opened, the dates update: Function Timestamp(Reference As Range) If Reference.Value <> "" Then Timestamp = Format(Now, "dd/mm/yyyy") Else...

Hello everyone! I have a huge problem. we utilize a "to-do" list with checkboxes that are inserted into each new sheet with the following code: Sub InsertCheckBox() Dim rng As Range Dim chkBox As CheckBox Dim cell As Range Dim i As Integer ' Set the range where you want...

Hi all, Hoping this is a simple fix. I have the below script that I found on another forum that runs as a rule in Outlook to save .pdf email attachments with a timestamp that come from my printer. That part all works fine. The problem I'm having is that it will save the file with the .pdf as...

Hello everybody and you all do an amazing work. I need your help please and i apologize in advance for any mistakes (English is not my native language). So, I have made the following: In B column appears a timestamp when in column C somone inputs a code which automatically reaplaces it with a...

Please help me out to figure out a formula to calculate Date/Time Base Bins (See attached Image).Whenever The ID Creation(Column A) on Current Day and Time 3:00 PM to 6:00 PM, In Column C "> 3 to 6 PM" , Current Date and time between 6 to 7 PM in Column C result should be " > 6 to 7 PM", after...

I need to compute the total time in which a system was down, and it looks like using the SUM(C1:C20298), it's not working for me, it's giving me some results that are not accurate.. The problem is that I have random timestamps like 17:27:22.432, then 08:04:25.532, and those are over 24h, so it's...

Hi everyone, Thanks for reading my post, I'm looking to highlight duplicate values within 24 hours from the previous duplicate value. I'm using this but this is not what I want, I would like to replace NOW() with the timestamp of the previous duplicated value (if exist)...

Hi, Is it possible to create a time based graph in Excel where I can plot a bookmakers odds against the Timestamp (Timevalid) on the axis and the odds on the y axis? I would like to define which Bookmakers to include in a filter for the graph (is this a pivot graph?) as well as which selection...

Hi, I have a VBA code which I found which works great for the purpose of tracking date and time of changes in each cell. I'm wondering if I'm able to change the code to report on a set sheet rather than being an offset. Private Sub Worksheet_Change(ByVal Target As Range) Dim WorkRng As Range...

Hi everyone How am I able to insert the username in the column "Closed by" and the actual date in column "Date for closing Claim Internal"? I tried with this VBA code, but it only take line 31. Private Sub Closed_by() If Range("AJ31") = "Closed" Then Range("AK31").Value =...

Hi Folks, I have a table with upwards of 1000 entries on it and multiple people will be working off this file (not at once). The idea is simple, you check a check box and it adds a time stamp into the "Sent Date" column. Each box is linked to the neighboring cell. However using the NOW() or...

Hi, I have a timesheet on google sheets where a timestamp is generated in a cell when someone presses a picture of a clock on the sheet. Is it possible to lock cells so that it rejects all input that is not generated through the timestamp script but still allow specific authorized users full...

Hello! I have stumbled on this community and man, do I have a problem that I can not solve by myself! I have a spreadsheet in which I have data in columns A-F that I add to regularly. I recently wanted to update it so that I have a timestamp of when each cell in column A was entered. The issue...

Hi guys. I'm a bit new in VBA coding, but have worked with Excel a lot. I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables. My formula right now is...

Hello, Ive been trying to figure this out for hours with no luck. I have a column with times listed the format in the cell shows hh:mm but the value in the formula bar shows hh:mm:ss The program i am feeding this information through recognises the actual value (shown in the formula bar) and...

Hello, I have a spreadsheet with a column containing timestamps (format dd/mm/yyyy hh:mm:ss). I am trying to select certain dates: within a certain month, within a certain year etc. The month I want to select within is selected in a combobox (format yyyy/mm). The way I'm doing it is comparing...

Dear all . I hope you can help me with the following problem : Have created 2 timestamp functions with VBA , one for the date and one for the time in order to use them when a specific value is changed in a specific cell . For example when data is changed at cell C then cells A & B are...

Hi! I have a table that I put into a subform so users can fill out portions of the data. The user will review the work and write in who is responsible, the credit category, cause, and notes. I want to hide the TINITIALS (username) and STAMP (time stamp). I want to use an Event, but I can't...

Hello, I have a sheet with multiple rows of data. In column A there are check boxes. What I need is code that puts a timestamp in column AC when the box is checked in column A of the same row. Column AC is also the last Column of the row if that is helpful. Thanks, new to VBA and trying to...

Hello: My workbook has 2 sheets, "Numbers" and "General". I have an If statement that runs at workbook close. If Sheets("Numbers").Range("BA2") = 0 Then Sheets("Numbers").Range("BA3") = "Correct" ElseIf Sheets("Numbers").Range("BA2") <> 0 Then...