now()

  1. T

    Using an IF statement to insert the time using NOW() but then not update it

    I'm working on a spreadsheet to track how many delivery vans I've loaded each day. The loading sheets have barcodes at the bottom which I scan into my table. They're in the format T<trip><date_as_yyyymmdd>V<van_number>, i.e. T001A20221024V101. At work the people on the desk have a spreadsheet...
  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. B

    How Do I Format NOW() to string in a Macro?

    Forgive me, I'm new to VBA. I have enough experience in programming, but it's not my bag. I'm currently trying a macro to copy data from one sheet to a table, and that data includes a NOW() function formatted the way I want. When I copy it over to the table, it's just copying the NOW() and I...
  4. 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)...
  5. L

    Problem with ISBLANK() functioning

    <tbody> in 8:00 8:00 out 12:30 12:15 in 13:30 13:15 out 17:30 total 8:30 6:37 15:37 15:37 </tbody> function for the first total (in cell B10)=IF(ISBLANK(B6:B9),"0",IF(ISBLANK(B7:B9),NOW()-B6,IF(ISBLANK(B8:B9),B7-B6,IF(ISBLANK(B9),(NOW()-B8)+(B7-B6),(B9-B8)+(B7-B6)))))...
  6. 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...
  7. R

    Deriving a live TIMEVALUE from the NOW() function

    Hi, I'm currently building a data model for my work, I've built a giant =IFS statement to return a value based on the current time: =IFS(AND(F3>=TIMEVALUE("00:00 AM"),F3<TIMEVALUE("00:15 AM")),"00:00 - 00:15",AND(F3>=TIMEVALUE("12:15 AM"),F3<TIMEVALUE("12:30 AM")),"00:15 - 00:30" ... "23:45 -...
  8. N

    How to keep NOW() and TODAY() From updating.

    So, I need to keep the NOW() and TODAY() from changing every time I change a cell or open the spreadsheet. I need the columns C, (TODAY()), F and G (NOW()) to stop updating once there is a time or date in the column. Thank you for the help! If you need anymore information Let me know.
  9. B

    Countifs matrix with date and time elements

    Hi, I am looking to work out if a list of items have been Completed, Due or Overdue. For completed, it should be in last: 24h, 48h, 72h, 5 days, 10 days. For Due, it should be in next: 24h, 48h, 72h, 5 days, 10 days, more than 10 days. For Overdue, it should be overdue by: 24h 48h 72h, 5 days...
  10. 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...
  11. M

    Enable commandbutton based on time

    Hi Guys, I have a cell on sheet 1 which updates every second with the current time. the format of this cell is hh:mm:ss. I then have a sheet with cells for different premises again with the format hh:mm:ss. I have a command button for each premises on a page. However, i dont want anyone to be...
  12. B

    Formula result memory

    I've been using excel for a few years now, I'm a little familiar with alot of things, but perhaps rusty when it comes to more indepth/technical stuff. Macros and VBA dont completely scare me, but I couldnt begin to start writing my own code from scratch. I'm going to have a large database of...
  13. D

    Update cell from form. Please help, running out of time.

    Firstly sorry for my to you easy to me impossible problem. Working in dairy need others to enter each cows daily milk production. Want form for cow by cow entry. Row 1 Date Colomn A cow's id no Colomn B cows name(vlookup on form) C: Amount of milk VB to update now() for column, entered id...
  14. R

    Now()

    Hello, Can I use the NOW() formula but make the values set so that the results do not change as the days change?! Thanks
  15. K

    Macro help- Push button that tracks what time it is pushed

    Hi all, I have a very basic background in macros but I am attempting to create a macro that when the button is pushed, a spreadsheet will track what time it was pushed at. Does anyone have suggestions? At this point I have just tried recording the macro by doing that, but on the spreadsheet I'm...
  16. K

    Using the NOW() function in Excel 2007

    Hi, I have a form I created for my office that uses Excel 2007. To create a unique ID for each form completed I created a formula that takes the name entered in one cell and concatenates it with the date & time in the adjacent cell. The date and time is calculated using the NOW() function in...
  17. 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...
  18. B

    Help: System Date and Time w/Formula

    Hi Team, Is there a way to capture the system date and time by way of formula without it updating each day? Rather than having to use the =Now() function and then copying and pasting it as a value. Cheers :eeek: ​
  19. J

    adding date and time to save-as file name VBA

    I'm puzzled by the problem I'm having: I want to save the current sheet as a PDF with the filename "Receipt YYYY-MM-DD HH:MM.pdf" (That is YEAR-MONTH-DAY HOUR:MINUTE) I have this working: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "S:\ ...\Receipt " & Format(Now...
  20. S

    vba help for copy range every 15 minutes

    i get in my work sheet prices updated from exchange in row 2 every minutes for 30 cells i.e.from cell A2 to Z2 i want to copy value of this row copied every 15 minutes in same worksheet from row 3 onwards( or new rows ) for study of rate changes every minutes i use excel 2007 thank you for...

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