time stamping value

  1. P

    Log file where each line gets a date stamp when populated and where date is then stored as value

    I have a simple log file with a couple of columns to log events. One row for each event. Every cell in a row is manually entered and there are no macro's or formula's yet. To prevent mistakes I now want to make a modification in column A... the date column. As soon as one of the other cells in...
  2. S

    How to set cell A1 to pull from Cell B1 but then remain static even if B1 changes?

    My company creates an ID for each product based on certain attributes of the product (size, colour, etc). The problem is I need to make it such that if those attributes change the ID must not update. Is there any way to say run this formula once but do not update? Currently I just cut the ID...
  3. X

    Time stamp for a specific cell value

    Hello guys, I have something like 300 rows. I want to get a time stamp at column A when column B is equal to "Non" (by default it is equal to "Oui"). To do that, I have to change the value of column C which has a conditional formula. I can change the value at any row, and I want the time stamp...
  4. S

    Time analysis - Counting time (hours) - counting each time stamp

    Good morning everyone, I am back to this amazing forum that has given a LOT to excel community and thank you everyone for that :) So I have this spreadsheet where it is basically call center data so in one of the column it shows time of inbound call as example (21:12:05) and other columns...
  5. R

    Time stamp value

    Hi Experts, Need help to solve by macro, Find below table from which a new table should be populated for every user and a numeric 1 value should be inserted at every minute. ST time is the starting time value and ED time is the ending time value. Pls guide. Raw table, from this we need to...

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