timestamp

Hi all, Have timestamps in column O that can either be blank or non-blank, I'm looking to find the last time stamp in column O If I'm on row 44 in column A, and the last timestamp is on row 41 in column O, how do I say to excel: LastTime = Cells(ActiveCell.Row, "O").Selection.End(xlUp).Value...

I have timestamp under Column A in this format: 2019-06-27T16:05-0400. I want only 16:05 from that timestamp i.e. hh:mm. Can someone help how we can do using macro? Source <tbody> 2019-06-27T16:05-0400 2019-06-27T16:10-0400 2019-06-27T16:35-0400 </tbody> Target: <tbody> 16:05 16:10...

Is there no way to create a timestamp in excel with out using a macro? I really need a timestamp but I have tried using a macro and it just isnt working its more headache than its worth.

Hi, so i am trying to get one last thing working on my work excel before i leave. I have tried a couple of the macros that i have found on this site, but couldn't get them to fully work. So basically i have 12 cells where they update automatically and i am trying to set it up so they also...

I have the following code that puts an automatic timestamp in Column B when a value is entered into the same row in Column A. HOWEVER, what I need is this: When a value is entered in a cell in Column A, the automatic timestamp is created in the corresponding row of Column B AND Column E. Is...

Hello I am trying to get a shift name based on a timestamp in a different cell. For example if my timestamp says "6/19/2019 13:41:37" I want the word "First" to show up in the next column to identify the shift name. I have searched and searched for an answer to this and cant seem to find it...

Hi I need to write some code which adds a time stamp that will not change to a list of cells in a column. To give a sample example, when a button is clicked, the code would at a time stamp to the beginning of each of the cells below. The data below covers 4 rows, with the numbers 1, 2, 3...

Hi All, Any help attained would be great, I am not the best using VBA so hence the query. I have a sheet where users submit their completed work and a cell calculates the % of work done. I have 4 other cells that have % thresholds from 25%/50%/75%. Is there a way for me to have a timestamp...

Hi all, Excel 365 here. The newer Excel version changed the old “comments” as “notes” (renamed this way), and added a new feature under the mention “comments”, which works like a thread with possible replies, where on top of input text, the autor is mentionned with a timestamp. I’d like to...

I set the cell format as time and 24 hr. So, when I enter 21:10 the time displays in the cell that way and if I enter 9:10 p the time displays as 21:10, just as expected. However, when I use the timestamp shortcut (Ctrl+Shift+:) the time displays as 9:10 pm. How do I force the timestamp...

I want to add 7 hours to timestamp if time is 01:00:00AM and add 1 hour if it's not 01:00:00AM. I tried - if(A2=TIMEVALUE("01:00:00AM"),A2+TIME(7,0,0),A2+TIME(1,0,0)) A2 = <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>08/Jan/19 8:0:0AM 1...

Greetings! I'm a real newbie to VBA and I have been stumped by this formatting of cells. I have Excel files (lists for gages due calibration) that we post for production. These lists are Excel files generated daily by our gage management software. I have a macro that opens each file and...

Hi guys, I have 10 digits timestamp, how can I convert it to date and time? See below samples 2018050212 = 05/02/2018 12:00 2018030601 = 03/03/2018 01:00 2018060415 = 04/06/2018 03:00 2018122520 = 12/25/2018 08:00 Thanks in advance ???

There is a workbook on shared location.. Everybody uses saved copy. Is it posible when the copy of workbook is opened to check value of SHeet1 in a1 cell (timestamp) of original closed workbook..and if the timestamp of original closed book is newer than create msgbox that says there is a new...

Hi Introducing myself, my skill in Microsoft excel is very basic. So my codingskill is minimum to zero. But I want to help an NGO to create a simple system to track collection Tin time In andOut, for their yearly event. They have been performing this event for decades,and is doing this all old...

Hi, everyone. Sorry if the title is kinda vague, but what I was trying to do is coming up with a formula for computing the number of work hours for each employee based on their schedule against their timestamps. Then, also compute their lates and absences. Here's how my tables would look like...

Hi guys, I have to following problem: in a workbook with many sheets I have to update several worksheets (Store A,B,C,D,E,F,G,H, etc). But I would like to have a overview sheet (Info) where all worksheets are named with a time stamp when the sheet was updated Overview sheet is called Info...

Hi guys, I have to following problem: in a workbook with many sheets I have to update several worksheets (Store A,B,C,D,E,F,G,H, etc). But I would like to have a overview sheet (Info) where all worksheets are named with a time stamp when the sheet was updated Overview sheet is called Info...

I have a timestamp I've previously talked to people about. It's a worksheet_change item and I either need to make it into a macro that runs automatically (so when I input data into "R5" it puts a permanent, non-changing/updating timestamp "dd-mmm-yy" in "F4" The fun part about this- it needs...

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...