timestamp

I have an excel list with name of employee, check-in timestamp (yyyy-mm-dd hh-mm-ss AM) and check-out time (yyyy-mm-dd hh-mm-ss AM). The timestamps are not marked as checkin or checkout unfortunately. I would like to calculate the time difference between the lowest time of date X and the latest...

Hi all, I'm working on a db I inherited, and I'm troubleshooting a query that returns duplicate values. The problem is a table that either generates a timestamp, or the timestamp is passed from VBA during some other query, BUT the timestamp is invalid, inconsistent, and changes frequently...

I have a document that I want to be signed twice. I know on Excel you can have a signature line but once you sign that once, the file is final and can't be edited without removing the signature line. How else can I capture two signatures?? If I could also have a cell auto populate the date and...

Hi All, I think this is a common question, but can't find the answer. I am working with 2013 on a workbook with about 30 sheets/tabs. I would like a timestamp cell in each sheet which will trigger only when another cell in that same sheet is changed. Each sheet timestamp must independent of...

The following code timestamps a sheet only when it has been edited: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("G10:K10")) Is Nothing Then Range("G10:J10") = Now Range("K10") = Sheets("Numbers").Range("BC2") Cancel = True End...

- I have a workbook that contains 10 sheets - I would like a timestamp to appear in cell G10 for when any edit is made in one specific sheet i.e. The specific sheet is named "General", so I'd like the timestamp to appear in G10 in "General" - I don't want the timestamp to change if edits...

Hi MrExcel community, I've used the following code a few times to get a timestamp when a range of noncontiguous cells are populated. However, now I'm trying to get the timestamp to clear if any one of the populated cells within the range is cleared. Currently, the timestamp only clears if when...

I'm looking to put a timestamp into "G7" when I click a button and then every time I click that same button it puts a timestamp into the next cell in that column (i.e. G8, G9, G10, etc.).:confused:

=IF(A2<="12:00","Before Noon",IF(AND(A2>"12:00",A2<="15:00"),"After Noon",IF(AND(A2>"15:00",A2<"19:00"),"Evening","Night"))) I have a column of timestamps..i need to create buckets like before noon, post noon etc. I am using the above formula but its not working. can anyone help me with it?

I'm getting a compile error on my spreadsheet that works on a Windows 32bit system, but not on my upgraded Windows 64 bit system. I'm not familiar with what's needed to correct this. Could someone please help me? The error occurs for a Private Function: Private Declare Function...

Hi, I have two worksheets sheet 1 sheet 2 In sheet 1 I a have two cells that I would like to autofil with username and timestamp when data is changed on sheet 2. A1 = username A2 = timestamp If anything changes on sheet 2 I need A1 and A2 to have the username and timestamp automatically...

Hi Excel people, I've been looking around for a solution to my problem, but only a partial solution exists so I kindly ask you for your help. I have an excel sheet in which I have the following: B1 = "clock" => now()-today() B3 = "time_threshold" => set to "13:00:00" in this example now A6...

Hello! :biggrin: I am new to the board and new to using VBA in Excel. Pardon me if I am not describing stuff well. Anyway, I am currently working on building a break/lunch log sheet for my team that does not require my supervision. Currently, everyone has this log sheet printed and I have to...

Hi All, I have a spreadsheet that will eventually contain a lot of data and I want to be able to use formulas and data validation to populate that data onto another sheet by date. I can't use the filter tool in my case. On the sheet with all the data column A has a timestamp formula...

I would like to know if there is a way to automatically insert a timestamp into a cell when a hyperlink is clicked. I have a document with hyperlinks in column G. I want to populate the cell to the right in column H with the timestamp for when the hyperlink is clicked. So if the hyperlink in G2...

Hi guys, First time posting here, i am stuck with a timestamp issue i want B10 to update with a timestamp whenever text is entered into B57 and to show empty when B57 is empty or cleared. I originally used the formula =IF(ISTEXT(B57),NOW(),"") However the time updates whenever the sheet is...

Hi all, I want to hide rows based on a timestamp in column A. If the timestamp is a day old, hide the row. The code below used to work great but I just updated the workbook and the problem is that the code is only working for one of the worksheets (past date rows are hidden), while the other 4...

Hi guys, I have a big file with columns D & E that contains time of starting an action (D) and finishing the action (E). I need the time in a custom format, like: mmmm dd, yyyy hh:mm:ss AM/PM Records are from the last 2 years, but i'm interested in a specific month, let's say, January 2017 and...

Hi, I wonder whether someone may be able to help me please. I'm using an adaptation of one of Ron de Bruins email scripts below: Sub Email() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim Src As Worksheet Dim fNameAndPath As Variant, wb As Workbook...

I want to find the maximum number of times a person accessed a system in any ten-day period. The data are a single row for each occasion that the person logged in, including a timestamp: Person Date Login xxx 2/1/17 10:03:01 yes xxx 2/1/17...