stamp

Hello everyone, Couldnt seem to find the correct formula for what I am trying to do. In Column O There will be a Yes or a No depending on Checkbox selection on userform. Say cell O2 is entered or changed to true then I want cell P2 to have a non changing date stamp. here is a screen shot of...

Hello I am trying to write an IF statement using date/time/hh:mm:ss data and would appreciate some help. I have ~ 150,000 rows of data so am keen not to review line by line. I have an extract of data with a date time stamp and I have calculated the difference between two times. eg: I have...

Hi I'm designing a database which has an Excel front-end and uses Access for data store. Each save from Excel to Access is a normalised table showing data for: A (one) Client which has 0 or more Jobs and where each Job has 0 or more Transactions If I need to reload previous saved states for a...

I have a table of data that shows activity in relation to users web activity and I need to establish a time spent on each page for each user. My data has User name Time landed on the page Any Links clicked on the page As I have the time the user landed on the page via the link clicked I need...

I'm having a big problem with a set of routines (I won't explain them) Is it possible to call a routine from a Sub, and return the ID of the calling Sub (maybe its not worth doing) I want to list each sub entry and a time stamp to be able to focus down on what the issue is Sub One Reporting End...

I have an excel workbook with a worksheet that has 78 columns of data (a lot I know) and was looking for a way to add a date/timestamp to each field so that I can filter and find when a field was changed in this large data set. I found the below code here, and it works really well however, it...

I need a formula that when I enter a number on a designated cell it will populate it to the first column and date/time stamp it. Also need a formula that at 7 p.m. it will email the sheet to a certain email address. It would also be nice if it could clear its self every night. Btw cant be macros...

Good day all, Please, I have a slight problem. I created a userform with 40 textboxes that submits its contents to sheet1. The userform generates a time stamp in a label (label2) using Format(Now(), "H:MM"). When I click the submit button upon filling the form, each filled textbox is...

Hi, I a pretty new to VBA and would like some support. What I looking for is a piece of VBA code that will date stamp Column O Username Stamp Column P, based on the status in column K being changed to either - Resolved & Ignore/Resolved. Ideally id like the O & P cells to be locked down an...

Hi, im trying to build a formula that can check a date and time stamp is between two other calculated date and time stamps. If this was a value issue I would use a IF statement e.g. answer 10 between 5 and 20 =IF(and(a1<=5,a1>=20,"Yes","No") But when it comes to date and time stamps I want to...

Hi, I'm fairly new to Excel and trying to setup 2 Columns. Column A will have a regular text entry (name) and then I'd like column B to give a Date and Time stamp every time I enter a new text in each respective cell in the A column. I tried various methods I found online but nothing worked...

Okay, I'm running a macro and part of the macro says this: tCell = Now tCell.NumberFormat = "mmm d, yyyy hh:mm" I like this because of the date and time stamp. Now that I've entered this macro, it has messed up my conditional format which colored the row if the cell matched today's date. Now...

Hi, I am not knowledgable in VBA at all. I have found the following that works a treat to time stamp in column J when column K is not equal to nothing. BUT, I want a separate timestamp that will time stamp only when the selection in Column K is specific i.e. "3. Send to Accounts" Private Sub...

i can use =now() but that also gives me the date in front....is there a simple way to only have the time?

I'm using the formula: =IF(E3<>"",IF(K3<>"",K3,NOW()),"") to date stamp in K3 when an entry in E3 is made. I have itterative calculation enabled to 1000 iterations. I have formated K column to date. However, whatever I input the date 00/01/1900 is returned. What am I doing wrong to get...

Hi, Please help me to write a code for the below mentioned scenario. I want to put a time stamp using =now command in VB in a range of cells (example B2:C25) and cells will be locked once the data is entered with a password and apart from B2:C25 all the cells are editable and unlocked. Need an...

Hello Peeps, Good day to all. I would like to seek help on how can I sum of duration of hours. I attached a file in here. What I want to do is to sum the total number of pause, online and offline in my data. Each data has its time stamp so i think it can be done but not sure where to start...

Hi there, I currently have a drop down list which requires an individuals unique password to change it. Once a name is selected/the correct password is entered, I would like an initial and date stamp to be applied to the cell to the right of the drop down list. This stamp should only change...

Hi there, I'm wondering if there is someone nice to type up a macro for me. So, generally I need a macro that once a button is clicked, it will create a Time Stamp in the 'U26' cell automatically. Once a button is clicked again, it will then place a Time Stamp in 'U27' and so on... Any ideas...

Hi, I am looking for a help to create the checkbox. In the spreadheet column A1 to E1 has to be updated manually. Once the data is updated, i am looking to have a checkbox created in F column, if i tick the check box, first requirement is 1) cell A1 To E1 should get locked 2) in cell G1...