1. B

    Timestamp in Column AC when box is checked in column A

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

    VBA If Statement Evaluating After True

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

    Error retrieving getting data

    Can I receive assistance resolving an error running this code... The code is suppose to retrieve intraday prices. I email the author, but never received a response. Greatly appreciate the help. Thank you kindly ' Samir Khan' http://investexcel.net ' simulationconsultant@gmail.com ' Contact...
  4. R

    Get value of next non-blank cell above the activecell.row, "O" cell

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

    Need help in Timestamp format conversion

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

    non macro timestamp

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

    Timestamp Help

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

    VBA question - enter timestamp in more than one cell

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

    Shift name based on timestamp

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

    VBA code to add time stamp to a list of cells in a column

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

    Issues with timestamp now()

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

    Macro transform all notes into comments

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

    Timestamp shortcut format missmatch

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

    Add 1 hour to Timestamp with if statement

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

    VBA Format Cells Based On Data

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

    Timestamp formula

    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 ???
  17. N

    Make copy of workbook from another location comparing timestamp of two workbooks

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

    Scan Barcode to designated cell columns and timestamp In/Out with Macro

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

    Formula for Counting No. of Hours Worked Based on Se Schedule Excluding Time Outside of Schedule

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

    Timestamp on worksheet change

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

Some videos you may like

This Week's Hot Topics