now function

  1. JEH105

    IF NOW is between specific timeframes not counting both HOUR and MINUTE - HELP PLS :)

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

    Auto fill in and update current date/time whenever certain cells are filled

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

    VBA one cell returns date of last time another cell was edited

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

    Workbook SaveAs private function to include date & time stamp - saved file won't open

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

    Need help with VBA for today() and now() functions

    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)...
  6. M

    Function =now() in barcode format

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

    Application.Username & Now Function macro

    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...
  8. 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...
  9. A

    Now() Function not saving date correctly

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

    If Activate Command Results In Run Time Error, Then Test a Second Option

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

    Month(now()) help!

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

    Inserting a changing date and a static time

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

    Help with Date and Time Return

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

    Now Function suddenly produces error... help!

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

    Last Update timestamp w/o VBA

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

    conditional formatting based on time difference

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

    Now Function

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

    Application.WorksheetFunction(Now) getting error

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

    updating date every time particular cells' contents are changed

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

    Incorrect time displayed in cell

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

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