now function

Can anyone assist with figuring out a way to write out this function to where it takes both hour and minutes into consideration when comparing the NOW time? Details: This is the formula I have under John Smith 1 row...

ABCDEFGHIJKL1DAYDATADATE/TIME2DAY 1E2F2G2H2autofill date/time3E3F3G3H34DAY 2autofill date/time56DAY 3autofill date/time7 Hi, I have tried to post this previously but have yet to get this solved. I need Excel to automatically FILL-IN and UPDATE the current Date & Time in cell L2 (which is...

Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...

Hi Folks, I discovered some VBA to be able to save a workbook with a custom filename that contains date and time stamp. My goal is just to save the file as *.xlsx. The code below works in regards to saving the workbook with the bespoke filename; however, when you try and open the workbook...

I need a macro code inserted into my workbook that will stop the Today() and now() functions from recalculating every time a change is made in the work book. Students will be typing in numbers in columns A and E. When their number is inserted in column A, the "name"(column B), "date"(column C)...

Hi I am working on a data sheet for users, the idea is to capture the current date & time by scanning an external laminated barcode, there are various activities happening in the room, and, as and when a particular activity is completed, the supervisor scans a barcode (the barcode remains the...

Hi Guys, I hope you are all well. I was just wondering if anyone can help me I am just looking for a simple sub that simply puts the Application.Username in column E and Date and Time in Column F each time the macro is used and will create a list of Users And Login Times. any help would be...

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

Hey everyone! Thanks for any input on this issue I'm having. I have a workbook that has assignments that get done throughout the month. I need the date to autopopulate based on criteria so I am using the IF() and NOW() functions. The date populates fine, except if I save and close and then...

All, Apologies for the vague title - could not find a good way to word it. This thread plays off a recently posted one that a member was very quick to answer and get me on my way. I have a file name of "May Scrap Net of Reserve with scrap codes.xls". My earlier post centered around how to...

Need some help with the MONTH(NOW()) Function, as I need it to reference the month preceding the current month. Can anyone please help?

Hi...trying to find a way to insert/format the date in excel to be today date (will change everyday) but the time must be static at 4pm or 16:00. It defaults to 00:00 or 12:00AM so if theres a way please let me know. E.g i have on column with dates: <TBODY> Expiry</SPAN> 8/17/2012</SPAN>...

I am creating a Call Sheet to record Times, Dates, and Notes that the listed parties were contacted. The end goal is to be able to enter in a cell the notes from the call, then an adjacent cell will read time that the notes were entered. Is there a way to get the return of when a cell was...

Hi All. I have macros with this line of code: Application.Wait now + TimeValue("00:00:01") the macros have been working perfectly for months and then suddenly I get the word 'now' highlighted and this error in vba: Compile Error: Expected function or variable. What's happened and how...

Hello all! I am wondering if there is a non-VBA way to have a cell in a worksheet display the last time that worksheet was updated/modified (or maybe last time it was saved?). I know how to do this using VBA, but was wondering if there was a built-in function or some way of using the NOW...

I am having trouble creating rules for conditional formating based on the time difference between a static time value in a given cell (time due completion) and the NOW function. I would like to have the format of cells change as the time difference changes. I would like to have cells that are 4...

Hello, How to keep the date in the cell when I use "Now()" function? Example: I use: =IF(A38<>"";NOW();""). When i enter something in cell A38, I have the current date entered. I save and close the workbook. Two days later I open it, and now function recalculates the date. How to keep it. I...

Dear All, I am using Excel 2003 with Windows XP on a network. I keep getting errors with some code. In a sheet, I have: Sub GetUser() Range("Created").Value = Application.WorksheetFunction(Now()) Range("Author").Value = Application.UserName End Sub The code for the Author works perfectly...

Hi, I am working on a spreadsheet where I wish to have a column B where each cell shows the date on which the cell in the corresponding row of column A is manually updated by me. In other words, <table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="484"...

I'm trying to create a invoice number cell that incorporates the account number from cell C3 and the date and time the invoice was created. I entered this in the cell: =C3&" "&TEXT(A12,"MM-DD-YY-HH-MM ") It does bring in the account number and the correct date, but the time displays as 0-00...