time stamp

  1. S

    Subtracting Decimal Time (4.3 minutes) from time value 10:00 am

    I have the following values that are exported out of Epic EMR (electronic medical record). The first column is a decimal time value, for example the first example is 4.3 minutes. I want to subtract the 4.3 minutes from the time stamp of 10:01 am in the second column. I realize I could manually...
  2. A

    Independant time stamps ...

    Hail Excel-lent ones. I've used this site often in the past to much success, but I've found a problem I'm not sure how to work around. I need two independent time stamps to be auto-filled based on the completion of adjacent cells. This part works in generating the stamps, but updates when the...
  3. M

    Time Stamp

    I'm trying to find a solution to my issue. I have a set of data the first two numbers are current line production total and the second is the running total. The second row has four times 8am, 10am, 1pm, and 3pm and below that are the target line totals per the times indicated above. I'm looking...
  4. T

    Macro to Lock entire row after input

    I am working on a spreadsheet that users fill in every hour. I have formulas for putting time stamps in column "B" when they add their initials to to column "A". They need to fill in other information in the row before they add their initials. Once they put their initials in then the entire...
  5. D

    Multiple TIme Stamps in a Row

    I reviewed several post on using VBA to insert a time and date stamp when data in a row changed and implemented on that changed one column if anything in the row changed. I then tried modifying it to insert stamps in different locations to track different cells in the row. The result is the...
  6. S

    ActiveX Button that shows time pressed

    Hi Guys, I'm looking to try and get an ActiveX button to display the time a which it was pressed. It is for a status board that will indicate when an action was done (the button will then be pressed). It's for a ship and the ship travels to different time zones so there will be another button...
  7. W

    Cell is blank, but has a formula in it.

    Greetings, I'm using a Surface RT, therefore, I can't use VBA. I'm trying to put a 'Date' and 'Time' Stamp into two cells when data is added. But I check the time cell and do a difference between the time before. The cell for date, =IF(K8<>"",IF(H8="",NOW(),H8),"") DATESTAMP...
  8. C

    Matching a time stamp to a shift and identifying the crew....

    So, I have two spreadsheets. One has a list of data with a time and date stamp on it. The other has the crew shift schedule on it. Spreadsheet 1 A B C D 1/1/11 8:00 PM 42 637 11222 1/1/11 11:00 PM 66 499 10978 1/3/11 5:00 AM 27 529 10223 1/3/11 7:00 AM...
  9. S

    VB Script for a time stamp

    Need help with a vb script to put a time stamp on excel sheet based off criteria being reached Cell C5 formula is =SUM($E$9:$E$60)/C1 This is a calculated field. It determines the % complete. I would like to put a 'time stamp' in Cell F6 when Cell C5 is > or = to 90%. However, if cell C5...
  10. D

    Conditional Formating with Date Stamps

    I need to know if new entries are made within the last 7 days. I do not need the date posted to my viewing just a highlight in my choosing of color. I only want the conditional format to last 7 days then it can go away to normal format. Is this possible or is there an alternative function...
  11. S

    Macro to save as two files at once

    Hi, One of my Daily tasks at work involve preparing time stamp report. I run an SQL Query and get the data I need. Now inorder to present the data to relevant people I copy and paste the data on a template which is named "Promise Data Master" then the second excel file which is called "Hourly...
  12. V

    Referencing an updating cell by determined time.

    Hey all, I have a data feed, that provides a constant changing stock market price. I am trying to capture the price every hour to a different cell. For example Cell with data feed, feeds prices "100.00,100.01,100.20,101.00 " between time frame of 9:30-12:30. I am trying to format the data...
  13. T

    Auto Date / Time Stamp Within Single Cell Anytime Data Entered in Worksheet

    I wrote a date/time stamp macro to auto update in a single, specified cell every time data is changed or entered in any other cell for specific worksheets in a workbook that have various other macros and functions. The code works perfectly when the sheets are NOT protected; however, it no longer...
  14. E

    Highlighting Macro + Time Stamp

    Hi everyone, I'm constantly updating a list of clients on excel manually, this takes a lot of time and is utterly, utterly dull. I was hoping some one could help me with a macro that would take care of this? (Would it be practical if I could just copy and paste a bunch of names into a...
  15. J

    Time Stamp

    Hello, I am looking for a function that is related to Time Stamp. This is what i want to do. We use Excel Sheet which has a time by which the production should be done. What i want to do is, set up a function/macro that will alert my production planner ETA is nearby. What would be also cool...
  16. D

    Auto Add Date in Multiple Columns

    Hey, I'm trying to Auto Update a column once a preceding column is updated. For example, when I update D5, E5 will add the date. Likewise, when I update J5, K5 will add a date. It is important that the date inserted does not update with the current time of the spreadsheet, [ ie. now()]...
  17. O

    Editing Macro Into A Timer

    Hello! I'm still very new to macros and excel and right now, I've been using: Private Sub Worksheet_Change(ByVal Target As Range) Dim x As Long x = Target.Row If Target.Column = 2 And Cells(x, 2) <> "" Then Cells(x, 1) = Time Cells(x, 1).NumberFormat = "hh:mm:ss" End If End Sub Since the time...
  18. T

    How to date a specific cell when another cell is changed?

    Hello, I am trying to date stamp a cell when another cell has been changed from a drop down selection list. For instance: If cell A1 is changed, time stamp B1. I have tried both the following codes and they both work for 1 column. "Private Sub Worksheet_Change(ByVal target As Range) If...
  19. S

    Macro for calculating differnce between two cells

    Hi, I am using Excel 2007 and trying to create a simple macro for claculating differnce between two cells. <TABLE style="WIDTH: 222pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=295><COLGROUP><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254"...
  20. P

    Database Issues

    Hi guys,... I am trying build a database kind of thing, and i have 2 doubts regarding this, hope you guys will help on this.. 1. Is there possible to create time stamp,.. when the record is entered. Tried something with now() function A1= if(B1>0, now(),"").. A2, A3, so on ..but if something...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top